Hi everyone,
I have a subform [frmOrderDetailsSubform] on which I am trying to use DLookup as the controlsource for a field to look up the [OnHand] field in my query [qryOnHand2].
=DLookUp("[OnHand]","[qryOnHand2]","
I have a subform [frmOrderDetailsSubform] on which I am trying to use DLookup as the controlsource for a field to look up the [OnHand] field in my query [qryOnHand2].
=DLookUp("[OnHand]","[qryOnHand2]","
Code:
= Forms![frmOrderDetailsSubform]![Code]")
This works fine when I open the subform as a standalone, however when I open the subform as part of the main form I get a flickering #Error.
Any advice would be greatly appreciated.