Control Source

  • Thread starter Frustrated in Formland
  • Start date
F

Frustrated in Formland

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.
 
F

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.
Click to expand...

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.
 
Top