Open Report

G

Guest

I have a macro written into the 'On Click' event of an OK button of a form.
This macro has got just one command row:Open Report. For the 'Report Name'
field, I am trying to pass the report name from the value selected from a
list box in that form. The Report Name field says:
[Forms]![myForm]![lstReports]
where [lstReports] is the name of that list box
When I hit the OK buton, it doesn't open the report and gives an error
message saying that
"The report name [Forms]![myForm]![lstReports] that you entered in either
the property sheet or the macro is either mispelled or doesn't exist"
How can I make this work?
 
N

Nikos Yannacopoulos

You need to add a = at the beginning of the expression:
=[Forms]![myForm]![lstReports]

HTH,
Nikos
 

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

Open report only after checking that it exists? 2
Open a report only after checking that it exists? 3
Macro Error: Can't Find the Macro 3
Macro Expressions for Report Selection Form 5
Reports Macro 1
Open a form by selecting from a list 3
Contact Management Database Template 6
Access Access Report Works on One Machine but not Another 3

Top