Another Problem opening a report using a Macro

[clchris_80]

So I have a form in Datasheet view and when you click on a record in that form I want it to take you to a report with all the details of that record number. I have the On Click event set to run a Macro. The Macro is as follows:

OpenReport
Report Name Incident Report
View Report
Filter Name Open
Where Condition =[Event ID]=[Reports]!Incident Report]![Event ID]


Window Mode Normal

This Where Condition works for me open another form from the form with the same Event ID. Why does it come to a "new" Incident on the report?

[alansidman]

I don't work with Macros, but use VBA. So I am unsure, but shouldn't your
WHERE Condition reference the form and not the report. ie. Where Condition =[Event ID]=[Forms]!YourFormName![Event ID]

I don't know if this is a typo or not, but you have one closed bracket on Incident Report but do not have a corresponding open bracket.

Alan