Combobox values

[ms_]

Hi,

I have several comboboxes (6) on my form. What I need some help with is how to populate these comboboxes with values depending on selected value in previous combobox.

Example.
Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc...

and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...

How do I make this happen in MS Access 2010 =) ?


Regards,

 

[pr2-eugin]

Hello ms_, Welcome to AWF..

What you want is called as Cascading ComboBoxes.. Google the keywords should return several hits.. Some good ones..

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html
http://www.datapigtechnologies.com/f...combobox3.html
http://www.fontstuff.com/access/acctut10.htm
and http://www.baldyweb.com/CascadingCombo.htm

If you do not follow any of them post your specific query, then we will do our best helping you out.. Good Luck..