B
Benjamin
I am trying to open a report that only will show records that meets certain
criteria. This is in a .adp database and I am having some trouble with it. I
tried creating a macro and defining a where caluse of:
[Student]=[Forms]![FrmSubStudent]![Student] and
[Scenario]=[Forms]![FrmSubStudent]![Scenario] this isn't working though, when
I click the button connected to the macro it gives me an error message
"Invalid SQL statement check the server filter on the form record source"
Does anyone have an idea to what I may be doing wrong?
criteria. This is in a .adp database and I am having some trouble with it. I
tried creating a macro and defining a where caluse of:
[Student]=[Forms]![FrmSubStudent]![Student] and
[Scenario]=[Forms]![FrmSubStudent]![Scenario] this isn't working though, when
I click the button connected to the macro it gives me an error message
"Invalid SQL statement check the server filter on the form record source"
Does anyone have an idea to what I may be doing wrong?