I have a form with several subforms on it. Each subform is on a different Tab using the Tab control. I am pulling information from the first tab onto the second by setting the default value of the field to the control on the first tab.
Code:
(=[Forms]![frmProjectData_PM]![sfrmProjectBudget_Summary].[Form]![HI_BudgetColorID])
However, if the data is missing in the first tab I get a #Error result in my field on the second tab. I want to display a custom message like "Please complete Tab 1 prior to completing this Tab" instead of the #Error.
I have done this in Excel by doing a nested if function, so I tried it on the form but it doesn't work:
Code:
=IIf(iserror(Forms!frmProjectData_PM!sfrmProjectBudget_Summary.Form!HI_BudgetColorID),"MISSING",Forms!frmProjectData_PM!sfrmProjectBudget_Summary.Form!HI_BudgetColorID)
Can this be done in access? I also tried the ismissing function and the nz function with the same result.