Printing a Report Directly from the Data Entry Form

[merv805]

I have a purchase order database. I have an autonumber field (Purchase Order ID#) that gets generated when the user inputs data. I would like to insert a command button into this form that grabs that Purchase Order ID # and brings me to a report that displays the same information, with out all the combo boxes, cmd buttons, etc.

The method I use now is the long way: I created a button to open a report based on a query that requires the user to type the ID# before you can print. I want to by-pass that step and automatically be able to pull up that report based on the autonumber field.

Thanks for any help offered.....

 

[humbleprogrammer]

Change your query to look at your forms purchase order id field. For example lets say your form is named form1 and your autonumber field is named POID.

- Open your query in design view.
- Type Forms![Form1]![POID] in your queries Purchase Order ID criteria.

** Of course replace the Form1 and POID with the real form and text box names.

This will tell the query to pull the ID from the form rather then prompting for the value.

Hope this helps.