G
Guest
Is it possible to filter a combo box to only show data based on the results
of the users choosing of information in 2 other combo boxes? I know this is
possible to do with 1 combo box, but can it be done based on 2 combo boxes?
Here is the code I have now and was just thinking I could add an "AND"
statement with another WHERE clause to the end of the statement but that
doesn't work.
SELECT [All Audit Test].Audit, [All Audit Test].AuditType, [All Audit
Test].Location FROM [All Audit Test] WHERE ((([All Audit
Test].AuditType)=Forms![Master Data]!AuditType));
of the users choosing of information in 2 other combo boxes? I know this is
possible to do with 1 combo box, but can it be done based on 2 combo boxes?
Here is the code I have now and was just thinking I could add an "AND"
statement with another WHERE clause to the end of the statement but that
doesn't work.
SELECT [All Audit Test].Audit, [All Audit Test].AuditType, [All Audit
Test].Location FROM [All Audit Test] WHERE ((([All Audit
Test].AuditType)=Forms![Master Data]!AuditType));