Use Dlookup() on report text box

[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

 

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

 

[Allen Browne]

See:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

The end result will be something like this:
=DLookup("[SomeField]", "[SomeTable]", "SomeNumberField = " &
[MatchingNumberField])