Open report from active form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 31 May 2005 15:28 GMT

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.

Reply to this Message

Al Camp - 31 May 2005 16:59 GMT

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

> access 2002 question:
> After entering data in a form, I would like to print the same data on a
[quoted text clipped - 5 lines]
> info.
> I have minimal VBA experience. Thanks and any help appreciated.

Reply to this Message

Klatuu - 31 May 2005 23:51 GMT

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.

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

Reply to this Message