Opening a Report

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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing a text field in a report to a Date/Time format 1
Access Access Report Works on One Machine but not Another 3
access report 0
Using Data from a Report in a Form 4
How to pass parameters to a report 2
Print a report 8
Moving data from a report to a form 4
Mutliply reports all at once 16

Top