Linking one combo box to another in a form

[hollmc1]

I need users to be able to select a value from one combo box and have their choice trigger another series of options in another combo box For example, if a user selects "Mike" from combo box # 1, another combo box shoudl appear allowing them to choose from a series of last names.

How can I do this?

 

[aleb]

Create two combo's, the query behind the second combo will have a criterea eq to value in first combo. Then on change event of the first combo place a code :
me.combo2.requery

 

[Mile-O]

Search on Cascading Comboboxes

 

[Jason999]

heres a good combo box example someone sent me, the second box is not hidden but one step at a time.

Hope it helps

Ja.