Display custom message in place of #Error

[darall]

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.

(=[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:

=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.

 

[PHV]

Perhaps this ?
=Nz(Forms!frmProjectData_PM!sfrmProjectBudget_Summary.Form!HI_BudgetColorID,"Please complete Tab 1 prior to completing this Tab")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[darall]

Thanks PHV! That didn't work but it got me to the answer! So simple, yet I have been struggling with it for days!

=IIf(IsError(Forms!frmProjectData_PM!sfrmProjectBudget_Summary.Form!HI_BudgetColorID)=-1,"Please complete Tab 1 prior to completing this Tab","")

Thank you!!!!