1 combo box dependant on another box in the same form?

[Guest_imported]

I have 2 combo boxes in the same Form. I would like to have the options in the second box dependant on the data entered in the first combo box.

An example of this would be doing a search for Automobiles.

The first box would be Make (manufacturer), The second box would be all models of that make (instead of all models of ALL makes)

I'm having trouble linking the two, I have the first box working just fine. I'm having trouble linking the second box (picking from a table with the field titles as the "makes" in the example, and subsequent "models" under each make) to the result from the first choice.

Any help?

TIA for any and all help!

 

[WMcGregor]

In the After Update timing point for the first Combo box, put this code:

me!Combo2.rowsource="Select Models from Manufacturers where Make = '" & me!Combo1.Column(0) & "'"
Me!Combo2.requery

This should cause Combo2 to only reflect the records you want...