Function dlookup in a subform

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

 

[Van T. Dinh]

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)

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.