Linking Combo Boxes 1

[snub]

I have a form that has two combo boxes. The first combo box asks for manufacturer and the second combo box asks for product. I want the second combo box to only show products from the manufacturer specified in the first combo box. Sort of like selecting a state and only having the cities from that state show up in the second combo box. I have no clue how to make this work.

 

[ClydeData]

See the file in access 2K that I've uploaded

http://homepage.ntlworld.com/jimmy.mcgeachy/TekTips/ComboBox.mdb

basicaly it is done through the SQL in the row source in the second combo

Hope this helps

Jimmy

 

[PHV]

And why not have a look in the FAQ area before posting ?

http://www.tek-tips.com/faqs.cfm?fid=4289

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[snub]

Thanks ClydeData and PHV it works now.

PHV, sorry for not finding the FAQ before I posted. I did a search but couldn't find what I was looking for. I'll dig deeper next time.