By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Creating a purchase order report

P: 1
I have a data base with about 4 different tables.
1. Cust info
2. Supplier info
3. Order History
4. Order details.

Order history and details are on one form with details being the
subform. This allows a 1 to many with the details.

This is all working fine. A person can input data into the main part
of the form and then go to the subform and add the details.

What I would like to do is create a button that the user can click on
that would print a report setup as a Purchase Order with information
on it from the main form and the detail form, so I can send that to my
supplier.

1.) I need it to print the current record that was just input.
2.) I need it to be able to re-print any record in the event the
original PO is lost.

I know this isn't very difficult to do but for some reason I cannot
get it started.

Do I
1.) Use a query to base the information?
2.) Then create a report based on that query and lay it out as I want it?
3.) How do I get it to ask for a specific transaction in the event I
want to re-print later.

4.)Are these two seperate items?

I hope I have been clear. Please feel free to ask any questions.

Thanks for the help.
Mar 21 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
1.) Use a query to base the information? Yes
2.) Then create a report based on that query and lay it out as I want it? Yes
3.) How do I get it to ask for a specific transaction in the event I
want to re-print later.

In the Report Open Code you have to set criteria based on the unique ID of the Order (I'm using OrderID as the example)

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "Report Name", acViewPreview, ,"[OrderID]=" & Me!OrderID
This will print preview the record corresponding to the current OrderID on the form.

4.)Are these two seperate items? No

Mary
Mar 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.