Does this look okay

[Steven811]

Hi

I've been trying to sort out my cascading combo boxes today, spent about 6 hours on it and got no where. My mind is fuddled and I could do with some help, does the following look correct?

[SELECT [tblCustomerDetails].[RepKey], [tblCustomerDetails].[CompanyName] FROM tblCustomerDetails WHERE ((([tblCustomerDetails].RepKey)=[Forms]![forCascTest]![cboRep])) ORDER BY [tblCustomerDetails].[CompanyName];]

This is the row source for the 2nd combo. It lists company names, by rep.

Steven811

 

[sfreeman@co.mer]

Creating a query with your SQL works fine for one cbo on one form, but only if you delete the first and last brackets.

Not sure if it is different in a multiple cbo situation.