How do I perform a DLOOKUP in a Subform?

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

Guest

DLOOKUP works when used in a stand alone form, but when I make the stand
alone form a subform, the DLOOKUP only returns ERROR.
How do I correct this?
 
The dlookup shouldn't return error when you are using it in a sub form, can
you post the dlookup you are using, and how do you use it
If you filter the dlookup on a value from the main form, the the path should
be different

=dlookup("FieldName","TableName","FieldName=" &
Forms![MainFormName]![FieldName])

Now if you filter on a number, it should be
=Dlookup("FieldName","TableName","FieldName=" & Value )

Now if you filter on a String, it should be
=Dlookup("FieldName","TableName","FieldName='" & Value & "'")

Now if you filter on a String, it should be
=Dlookup("FieldName","TableName","FieldName=#" & Value & "#")
 
Back
Top