Options in MS access

[jayanth via AccessMonster.com]

Hi All

I have an form. In the form i have initiall five options in category one. If
i select one option in category one, I need form to show all the options
related to option 1 in category 2. How do i do this. For example.

In Category one i have - Car name = 1) Ferrari 2) Mercedez 3) Renault
in category 2 i need the options to oly pop up the models related to mercedez.


How do i do this?

Thanks and Regards

Jayanth

 

[BruceM]

Assuming you mean combo or list boxe rather than option groups, there is a
general outline of what you need here:
http://www.mvps.org/access/forms/frm0028.htm

More detail and more options here:
http://www.fontstuff.com/access/acctut10.htm

A search for "cascading combo box" will turn up a lot of information on the
subject. These happen to be two links I have at hand.