Error displayed on the navigation form

[stephenchan433]

Hi Again



Have another issue.... How do I resolve #errors in the navigation form?

I have one combo box with the following code: =DLookUp("[INGREDIENT]","tblITEM MASTER","[RM_CODE] = Forms!frmRM_PricingFINAL!Combo46")
My Navigation Form is "frmNavigation"

I initially placed frmNavigation between Forms! and frmRM_Pricing but still ran into issues.

thanks in advance!

[ItsMe]

Navigation Controls are very finicky and difficult to troubleshoot. If you are building a desktop database vs. an Access Web App, I would recommend avoiding the Navigation Control and or using the Wizard to build a Navigation Form.

If you are going to use the Navigation Control, you might start by hardcoding a value that represents a valid value. For instance ...
=DLookUp("[INGREDIENT]","tblITEM MASTER","[RM_CODE] = 5241")
or
=DLookUp("[INGREDIENT]","tblITEM MASTER","[RM_CODE] = 'Some Text Value'")