Not the normal multi-comboBox question....
I have 2 combo boxes. cboCompany and cboLOB (line of business.
cboCompany pulls from tblProduct.Company
Row source SELECT DISTINCT tblProduct.Company FROM tblProduct;
I want cboLOB to look at cboCompany and then do an if/then check to see which company is listed and then list only those lines of business related. I DON'T WANT IT TO PULL FROM tblProducts. This is a new database and the data isn't there to just do a Select. I thought that this could be a Validation, but cannot figure out how to do it.
example: Company1 only had LOB's A,B, & D
Company2 has C,E,F, & G
Company 3 has A,B, & F
Company4 has B & C
Any suggestions? Need more info??? Any assistance is greatly appreciated.
I have 2 combo boxes. cboCompany and cboLOB (line of business.
cboCompany pulls from tblProduct.Company
Row source SELECT DISTINCT tblProduct.Company FROM tblProduct;
I want cboLOB to look at cboCompany and then do an if/then check to see which company is listed and then list only those lines of business related. I DON'T WANT IT TO PULL FROM tblProducts. This is a new database and the data isn't there to just do a Select. I thought that this could be a Validation, but cannot figure out how to do it.
example: Company1 only had LOB's A,B, & D
Company2 has C,E,F, & G
Company 3 has A,B, & F
Company4 has B & C
Any suggestions? Need more info??? Any assistance is greatly appreciated.