Leo_Coroneos
Registered User.
- Local time
- Today, 08:14
- Joined
- Nov 27, 2017
- Messages
- 107
Opening report based on current Order [SOLVED]
Guys,
I could do with some help with the final touches to my music store database, and it should come across as a very easy question to answer. My VBA programming primer book just arrived in the mail and I've searched the event procedure section for answers. I have also referred to links at MSDN and Bytes, but I am unable to post them due to my too-low post count on these forums.
My problem here is as follows:
I'm trying to open a report in Access that only shows the data from one order when the Review button is pressed (see picture Snip1).
Access is instead giving me the whole catalogue of orders (see picture Snip2).
This is no good, and it is occurring even after I implemented the following code into the Review button (see picture Snip3):
I.e.
Can anyone help? What might I be doing wrong? Thanks in advance!
- LC
Guys,
I could do with some help with the final touches to my music store database, and it should come across as a very easy question to answer. My VBA programming primer book just arrived in the mail and I've searched the event procedure section for answers. I have also referred to links at MSDN and Bytes, but I am unable to post them due to my too-low post count on these forums.
My problem here is as follows:
I'm trying to open a report in Access that only shows the data from one order when the Review button is pressed (see picture Snip1).
Access is instead giving me the whole catalogue of orders (see picture Snip2).
This is no good, and it is occurring even after I implemented the following code into the Review button (see picture Snip3):
I.e.
Code:
DoCmd.OpenReport "rptOrder", acViewPreview, , , , "OrderID = " & Me.OrderID
Can anyone help? What might I be doing wrong? Thanks in advance!
- LC
Attachments
Last edited: