Filter Combo Box on multiple other combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
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));
 
You can use more then one combo as a filter

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
And [All Audit Test].OtherFieldName = Forms![Master Data]!OtherFieldNameInForm
 
Back
Top