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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

synchronized Combo Boxes in subforms 2
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Filtering combo boxes based on a selection in another combo box 1
Synchronize combo boxes 2
cant get cbo to stop outputting key# 0
Filter Combo Box B based on Combo Box A Selection 4
Access Form - Lock Fields from Editing 0
Cascading Combo Box Selection Being Overwritten 1

Back
Top