So basically, I’ve created a form that displays the product details one by one. I want to make it such that, if they’re interested in the product shown, they can click a button or a check box in the same page. After going through all the products, they can then close the form and a report would be generated showing all of the products they’re interested in.
Is there a way to make this work? Any other suggestions/workarounds would be appreciated too. Thank you!
Tried adding buttons but I don’t know enough to make it work
1
You will need some VBA for this purpose. Put this code in your On Click event of the button for generating report:
DoCmd.OpenReport "YourReportName", acPreview, , "Interested = True", acWindowNormal
“Interested” being the name of the column where you store data from the checkbox.