Click on Record in Report and pull up form?

[Kumba1]

Is it possible to click on a record in a report, and have some VB Code open a form? I know how to set everything I need in the form on load, I just need to know how to get access to run the VB Code when I click on the specific record... any ideas?

 

[ssecca]

No can do. Access looks at a report as a single object. You can not select or invoke an event from clicking on a report.

HOWEVER, you can create a form that looks just like the report. display it on screen, the user can then interact with it or print it as needed.

Good Luck
ssecca