I have an Access 2010 database where I can produce a Report based on my various "products".
It currently lists all products and the relevant info to that product I have added. I have also created a Form with a drop down box of all my "products".
What I want to do is, click on a button next to the drop down box in my Form and select this "product" only to show in my Report. I have used the following to do this:
Expand|Select|Wrap|Line Numbers
- Private Sub Report_Click()
- DoCmd.OpenReport "xxTotSum", acViewPreview, , "[Article No#]=" & Me![ArticleNoBox], acWindowClose
- End Sub