Use Dlookup() on report text box

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a text box on my report which I want the
RecordSource of it to point to a quary where a certain
field in the query matches a certain field in the record
source of the report, both fields are Numeric, indexed;
could any one provide me the expression how to do that.?


Thanks

Scott
 
Set the control source of the textbox to something like this. You'll need to
modify it for the real names.

=DLookup("[FieldToReturn]", "[QueryName]", "[MatchingFieldName]=" &
[ReportFieldName])
 
Back
Top