Open report from active form

D

Dan

access 2002 question:
After entering data in a form, I would like to print the same data on a
report that arranges the form's entered data in a particular layout. What is
the best way to accomplish this? I was thinking of a report using a query as
the data source and a parameter input of the table ID having the record info.
I have minimal VBA experience. Thanks and any help appreciated.
 
A

Al Camp

Dan,
Your on the right track, but you can just use the ID on the open form to
filter your report query.
= Forms!frmYourForm!YourIDField
would only report on the one record with that ID.
hth
Al Camp
 
K

Klatuu

Dan,
It would depend on the data source for your form. If it is a table, then
you could use the table and in the report, set the filtering you need for the
data. The same would be true for a query.

This should not take much coding, you just need to set up your filter when
you desing your report.
 
Top