Command Button Question!!!

[Guest]

I was wondering if my dream can be a reality or am I using more imagination
than Dorothy (Wizard of OZ) lol. What I want to do is kind of create an
"invisible command button" . I have a chart and what I want to be able to do
is allow the user to click in a certain area on the chart and that action
pulls up a report. I am creating this chart in Form also. I don't want the
actual command button on there but if I have to I will use it. So is there a
way to create this "invisible button"?

 

[Guest]

You can use a lable, with this properties

1. In the Caption Property set few spaces, other wise the lable will be
removed
2. Set the BorderStyle Property to "None"
3. On the MouseDown event write the code that open the report

 

[Guest]

what is the code for opening a report? I didn't use any code, I was using the
wizard to set what to open. I am not a VB guy!

 

[Guest]

The command to open a report is

Docmd.OpenReport "ReportName"

Check this link on "Printing the Record on the Microsoft Access Form to a
Report"

http://www.databasedev.co.uk/report_from_form_record.html

 

[Guest]

Thanks!

The command to open a report is

Docmd.OpenReport "ReportName"

Check this link on "Printing the Record on the Microsoft Access Form to a
Report"

http://www.databasedev.co.uk/report_from_form_record.html