Daisy chained fields

[farscp1]

I have a form with a combo box field. I want to create three other fields that are controlled by whatever the user selects. For example course has course name, and type. I want the to field the user selects to be the course number and then two other fields are automatically populated, course name and type. How do I set that up?

 

[Remou]

You could create your combo with all the fields you want to reference. Then set the control source for several textboxes to:
=[combobox name].Column(n)
Where n is the number of the column to be referenced, starting at 0.

 

[farscp1]

Awesome. Thanks for your feedback. I will try and post my results.

 

[farscp1]

I am still having trouble with this. I tried and it didn't work. Here are the details:

Each department has some committees. Whenever the user select department A, committtees from group A should appear. If department B is selected committees from B should appear, etc.

The combo box for Department is called "department" the combo box for committee is called "comm_id"

How do I get this to work? Thanks for any suggestions.
Anna

 

[Remou]

Have you had a chance to look at
Combo Box - dependant on another Combo Box
faq702-4289?

A search for dependant (or dependent) combo will return a good number of records. Do get back, if these don't work out.

 

[farscp1]

I finally got this working. Thanks for everyones help/suggestions. Here is a link to the website I referenced:

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