Combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top