Creating 3+ combo boxes that depend on eachother

[abic131]

Thanks a lot for your help btw.

[abic131]

Crap sorry I left out the second column of the select statement again

[abic131]

SELECT qrySuppliers.[Company Name], qrySuppliers.[Supplier ID] FROM qrySuppliers ORDER BY qrySuppliers.[Company Name];

[ItsMe]

What you have done in your select statement there is to have the ID in the second column. To mach this, you will need to have the bound column property =2

[abic131]

Ok so I did this but it's still no working. Do I need to do something in Event?

[ItsMe]

In the after update event of your first combo you can requery the second combo

Me.SecondComboName.SetFocus
Me.SecondComboName.Requery

[abic131]

Alright so if this stuff isn't working could there possibly be a problem with my queries? I could try deleting them and working just from my tables. What's the benefit of using queries anyways?

[abic131]

YAY! Nevermind I figured it out! okay on to the third combo box. phew. thanks so much!

[ItsMe]

...What's the benefit of using queries anyways?

The ability of retrieving data from more than one table within a single dataset.

I am not sure what is working and what is not. If you like, you can remove sensitive data from your DB, Compact and Repair, Zip file down, and upload here. I will take a look at your combos.