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

Form Question- Preview Current Order on the Command Button

P: 42
I am trying to copy a format from one of the template from Microsoft Website access database (Inventory Management Database) where when you go to Purchase Orders Form and there is a preview order button command at the bottom and when you click on it, it shows the current order shown on the form as a Report Type (it pulls a report). I made it as far as to pull the Report and even got the macros working but for some reason it shows all the report and not the just the current one. How do I restrict to basically view the current order form?
Access 2003
Vista

Thank you very much!
Jan 30 '08 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I am trying to copy a format from one of the template from Microsoft Website access database (Inventory Management Database) where when you go to Purchase Orders Form and there is a preview order button command at the bottom and when you click on it, it shows the current order shown on the form as a Report Type (it pulls a report). I made it as far as to pull the Report and even got the macros working but for some reason it shows all the report and not the just the current one. How do I restrict to basically view the current order form?
Access 2003
Vista

Thank you very much!
You need to filter it on the primary key of the Order. Something like

DoCmd.OpenReport "ReportName", , ,"[OrderID]=" & Me!OrderID
Feb 5 '08 #2

P: 42
Thanks! That works.
John

You need to filter it on the primary key of the Order. Something like

DoCmd.OpenReport "ReportName", , ,"[OrderID]=" & Me!OrderID
Feb 18 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks! That works.
John
You're welcome. :)
Feb 18 '08 #4

Post your reply

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