I am trying to use an unbound form to enter criteria to filter a query.
I am using this SQL code.
SELECT TOP_LVL_IDENT, PSA
FROM PFEP_RACK_AUDIT_INQ;
WHERE (((TOP_LVL_IDENT)=[Forms]![PFEP_SWITCHBOARD]![INQ_ARRANGEMENT] Or IsNull([Forms]![PFEP_SWITCHBOARD]![INQ_ARRANGEMENT])) AND ((PSA)=[Forms]![PFEP_SWITCHBOARD]![INQ_PSA] Or (IsNull([Forms]![PFEP_SWITCHBOARD]![INQ_PSA]))));
I am getting an error from my query though. It is "Characters found after end of SQL statement. Why is this? How do I get this to work.
I want to be able to enter criteria in one, or both text boxes, and get a result from my query.
Thank you!