Hi all,
Could I please get some assistance in writing two SELECT Statement on two Combo Boxes?
What I would like is to:
On cboFilterRole I would like to make the select statement so that If the cboFilterIndustry Is NotNull,
then BusinessPrimaryRoleID, tblBusinessPrimaryRole, BusinessPrimaryIndustryID FROM tblBusinessPrimaryRole
WHERE BusinessPrimaryIndustryID= cboFilterIndustry and if it is null, then BusinessPrimaryRoleID, tblBusinessPrimaryRole, BusinessPrimaryIndustryID FROM tblBusinessPrimaryRole
On cboFilterFunction I would like to make the select statement so that If the cboFilterIndustry Is NotNull OR cboFilterRole Is NotNull ,
then BusinessPrimaryRoleID, tblBusinessPrimaryRole, BusinessPrimaryIndustryID FROM tblBusinessPrimaryRole
WHERE BusinessPrimaryIndustryID= cboFilterIndustry OR BusinessPrimaryRoleID= On cboFilterRole and if it is null, then BusinessPrimaryFunctionID, BusinessPrimaryFunction, BusinessPrimaryRoleID, BusinessPrimaryIndustryID FROM tblBusinessPrimaryFunction
This way if I select anything from the second and third combos it only shows me results that match the previous combo
Here is the table, row source info currently:
Code:
'tblBusinessPrimaryIndustry
'tbl Fields:
BusinessPrimaryIndustryID
BusinessPrimaryIndustry
'ComboBox:
cboFilterIndustry
'Row Source:
SELECT BusinessPrimaryIndustryID, BusinessPrimaryIndustry FROM tblBusinessPrimaryIndustry ORDER BY BusinessPrimaryIndustry;
'tblBusinessPrimaryRole
'tbl Fields:
BusinessPrimaryRoleID
tblBusinessPrimaryRole
BusinessPrimaryIndustryID
'ComboBox:
cboFilterRole
'Row Source:
SELECT BusinessPrimaryRoleID, tblBusinessPrimaryRole, BusinessPrimaryIndustryID FROM tblBusinessPrimaryRole ORDER BY BusinessPrimaryRole;
'tblBusinessPrimaryFunction
'tbl Fields:
BusinessPrimaryFunctionID
BusinessPrimaryFunction
BusinessPrimaryRoleID
BusinessPrimaryIndustryID
'ComboBox:
CboFilterFunction
'Row Source:
SELECT BusinessPrimaryFunctionID, BusinessPrimaryFunction, BusinessPrimaryRoleID, BusinessPrimaryIndustryID FROM tblBusinessPrimaryFunction ORDER BY BusinessPrimaryFunction;
Thank you all!
Dave