Use Dlookup() on report text box

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
 
W

Wayne Morgan

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])
 
Top