Selecting options and making it dynamic in forms

[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

 

[Jeanette Cunningham]

Hi Jayanth,
How much code have you written so far? Please post it so we can help with
this.
What controls do you have for this - option group? combo box? listbox?

What table is the form based on? What is its record source?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia