Filtering a Combo list from the result off a another Combo list

[supanoods]

This is bound to have occured many a time before - so if someone knows where please direct me!

I have a table called "machine" which holds two coloumns - machine name and area. The area is chosen from a table called area. The values for area are 1,2,3,stores.

I have 2 combo lists on my form - the first asks the use "what area is the machine in", the choices are determined from the area table. When a user chooses an area - I want the next combo box which is "which machine" to show only machines in the chosen area - these values are determined from table machine.

Therefore the question is: how do i filter the machine choice, based upon the area selection????


"If it aint broke - dont fix it!

 

[RoyVidar]

Yes it has occured some times, hit the faq button at the top of the page. The second section deals with comboboxes, and there's even two faqs on this topic.

Roy-Vidar