Open Report

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
You need to add a = at the beginning of the expression:
=[Forms]![myForm]![lstReports]

HTH,
Nikos
 
Back
Top