Function dlookup in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Function dlookup: using this function in a text box I get the right values if
I open the subform where the text box is in but #Error is displayed in the
same text box of the subform if I open the main form where the subform is in.
 
You probably use a reference to a Control on the Form being used as the
Subform which may need to be modified to work correctly as a Subform.

Describe relevant details of your Main Form, your Subform and your DLookUp
expression.

--
HTH
Van T. Dinh
MVP (Access)




Susi said:
Function dlookup: using this function in a text box I get the right values if
I open the subform where the text box is in but #Error is displayed in the
same text box of the subform if I open the main form where the subform is
Click to expand...
in.
 
Back
Top