Cascading Comboboxes using bound and unbound tables in one form

[dylcon]

Hello,



I have been struggeling getting my combo boxes to correctly cascade for quite some time now. What I am trying to do is have the user select a 'CustomerName' from the first combobox and then the second combobox will be populated with the coinciding 'PartNumbers'. I think what is making this so difficult is that the CustomerName is apart of one table and the PartNumber is apart of the bounded table. Here is my database in case it helps. I am working on the IncomingForm and I have tried to write it in VBA and SQL, but no luck in either.

New Compressed (zipped) Folder.zip

[rzw0wr]

Paste into your PartNumbercbo,

SELECT tblPartInfo.CustomerID, tblPartInfo.PartNumber FROM tblPartInfo WHERE CustomerID=  CustomerNamecbo;

Dale

[dylcon]

Thank you so much Dale. I don't understand what I was doing wrong, but I will use this technique in the future. Thanks again!