Combo box's table changing?

[harvey]

i have created a table that has two combo boxes in a single record. the first combo box has 5 values(1, 2, 3, 4, 5) and there are also five tables that are created for each option of this combo box. what i want to do is make the second combo box to swap through different tables depending on the choice of data from the previous combobox i.e. if the person chooses 1 than the second combo box just show the dropdown list of the data from table created for 1.

 

[Štef1]

Hello harvey
I think you created a FORM that has two combo boxes.
Look at "Demo2ComboA97.mdb"

 

[harvey]

thanks stef that was exactly what i wanted

thanks again because i have been looking for this function for ages!!!