Hello,
I have a form with a list area and a button to load a report.
Both of these use the same query and the result shows up in the list area fine, but when I click the button to load the report, it throws an error (3075) saying I have an error in the syntax.
The query is:
Can anyone help?Code:"SELECT ID,description,location FROM assets WHERE assets.sublocation like '*" & sublocation & "*'" & " And assets.[Date Removed] Is Null"
-Reginald