Pass infomration from a form to a report...

  • Thread starter Thread starter George
  • Start date Start date
G

George

I have a form that displays a certain fields from a specific record. How
can the selected values be passed to create a report?

From my understanding reports can only get information from tables and
queries. How can I query th information from a form?

Thank you for any help,
George
 
I have a form that displays a certain fields from a specific record. How
can the selected values be passed to create a report?
Click to expand...
From my understanding reports can only get information from tables and
queries. How can I query th information from a form?

Thank you for any help,
George
Click to expand...

Well, actually you can.

For instance you can base the Report on a Query with a criterion

=[Forms]![NameOfYourForm]![NameOfSomeControl]

to use that control's value as a criterion to select which record or records
to include in the report.

You can use the same expression as the Control Source of a textbox on the
report if you just want to display the value of an unbound textbox.
 
Back
Top