Single Report

[jayr911118]

I have a database with 3 tables and also have a form with 2 sub forms in it to enter data in those tables. I would like to print the information that I enter in the form by hitting a button on the form page that takes me to a report that only shows the information in the 3 tables that I just entered. I can figure out how to generate a report that shows all the information I need formatted in the right way but it generates for every record and the database is too big for that.

If your wondering why I just don't print the form after I enter the data it's because I need the output to look dramatically different.

I'd settle for a two-step process where after I enter the information and then go back to the switchboard and use a query to find the information and then have that information go into a report.

If anyone could help me that would be super.

-Jason

 

[mark curtis]

In the query that creates the report you must have somekind of unique ID .

Therefore in the query you can either put the following in the Unique Fields criteria [Enter Unique ID] and u will be prompted for the Unique ID.

or in the criteria of the Unique ID reference the form such as

=forms!mainform.[Unique ID]

 

[jayr911118]

Do I put that code in the VBA for the report so when the report opens it asks me and then I enter the unique id. If so, any idea what the code would look like.

Thanks,
Jason