Control Source

[Guest]

Not sure if my scenario will work...Hopefully, someone can point me in the
right direction....

Details:
I have built a report without a specific record source, i.e., unbound. On
the report I have several unbound text boxes that I would like to populate
with the values from several queries. Rather then creating sub reports for
all the boxes (there would be quite a large amount), is is possible to code
the control source (or something else) to pull in those values?

Any help is greatly appreciated.

 

[fredg]

Not sure if my scenario will work...Hopefully, someone can point me in the
right direction....

Details:
I have built a report without a specific record source, i.e., unbound. On
the report I have several unbound text boxes that I would like to populate
with the values from several queries. Rather then creating sub reports for
all the boxes (there would be quite a large amount), is is possible to code
the control source (or something else) to pull in those values?

Any help is greatly appreciated.

You can use DLookUp in your report:
=DLookUp("[Fieldname]","QueryName","[SomeField] = " & SomeCriteria)

Look up DLookUp
as well as
Restrict data to a Subset of records
in VBA help.