Getting multiple field lists for a form

[Guest]

I'd like to pull data from multiple queries/reports. How do I see the field
lists for additional queries/reports to modify a form I currently have?

 

[John Vinson]

I'd like to pull data from multiple queries/reports. How do I see the field
lists for additional queries/reports to modify a form I currently have?

I'm not sure I understand what you want to see. Do you want to be able
to have the same form display different data? Or an arbitrary number
of different sets of data all at the same time?

You cannot pull data from a Report into a form - reports don't
*contain* any data, they just display it for printing.

You can change the Recordsource property of a Form to display
different queries (of course you will need a control on the form for
each field in each query); or you can put multiple Subforms on a form,
each bound to one query.


John W. Vinson[MVP]

 

[Guest]

I want to see 3 different sections on a form called Project History, each
section performs it own searches and I want them to work independently of
each other:

I) a search by project number that allows user to enter project number and
click a button to bring up the info from the report; the search happens in
the detail section of the form.

II) a search for pending files that allows user to view and print a report
of all pending projects, he can also input a project number and search for it
alone after clicking on a command. search happens in detail section of form.

III) user enters a start and end date to search on projects' award dates. a
command button displays the search results in a report. the criteria are
entered in the header and the detail section displays the results.

I changed the record source to include all 3 queries and picked up the
fields that I want on my form. However, searches I and II above, pull in no
data. I am only able to search in III that has info in the header and detail
sections. any suggestions?

 

[Guest]

I kept the forms separate and generated a pop-up switchboard instead.