Open report from active form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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