Combo boxes

A

Ann

I want to create a combo box in my form. The combo box must equal to the
machine that I pick so that the right material I use for the machine would
come out on the list. Please Help.
 
O

Ofer Cohen

Check this link for one example

http://www.databasedev.co.uk/filter_combo_boxes.html

Another option will be to create a filter in the material combo that linked
to the machine that was selected in the form
In the RowSouce of the material combo add
Select Material From TableName Where machine =
Forms![FormName]![machineComboName]

On the after update event of the machine combo you need to refresh the
material list

Me.[material combo name].requery
 
Top