Form Field Auto Population

[Joe]

I wanted to create a form in my database that automatically populates sub
fields or sub combo boxes based on a selection in another combo box. For
instance if you had two combo boxes one that said manufacturer and another
that said model. The model combo box would be empty until you selected a
manufacturer from the manufacturer combo, then the mdoel combo would
autopopulate with all the models available from that specific manufacturer.

 

[Rick B]

Do a search. Asked and answered all the time.

Look for "cascading combo"

Rick B

I wanted to create a form in my database that automatically populates sub
fields or sub combo boxes based on a selection in another combo box. For
instance if you had two combo boxes one that said manufacturer and another
that said model. The model combo box would be empty until you selected a
manufacturer from the manufacturer combo, then the mdoel combo would
autopopulate with all the models available from that specific

manufacturer.