Opening a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just created an Access Database. I was wondering if anyone knows how to
open a report by clicking on a field in a form (e.g. UserID)?

I want the user to be able to open and print a report by clicking on the
UserID field in the form.

Thanks.
 
A command button has a click event just like a text box. The easiest method
might be to use the command button wizard to run the report. Cut the code
from the command button click event and paste it into the On Click event of
the UserID text box.

I would probably use the double-click event. There is code at
http://www.mvps.org/access/reports/index.html to open the report based on a
value in the form.
 
Back
Top