Linked combo box

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

Guest

I’m sure this is straight forward enough if I only new how. I want to create
two combo boxes with the value list in box 2 being dependant on the selection
made in box one. I would be grateful if anyone could point me in the right
direction or locate an example of this.
 
Check this link for one option

http://www.databasedev.co.uk/filter_combo_boxes.html
==============
The other option will be to filter the RowSource of the second combo using
the first one

Select FieldName From TableName Where Field2Name =
Forms![MainFormName]![Combo1Name]

On the after update event of combo1, you need to run the code
Me.[Combo2Name].Requery

to refresh the list
 
You must log in or register to reply here.

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

Use a combo box to find an Employee 1
Report displays numbers, not appropriate categories 10
On click event procedure with a combo box 2
Combo Box and Two Fields 2
using check box to control text box visibility 4
combo box data type 1
Combo Box 3
Multi Select list box as parameter for report or query? 1

Back
Top