How do I use one field to populate a Combo box in another field?

[Bob Green]

On a form I have a combo box that enables me to select 'Manufacturer' the
next control is another combo box that enables me to select 'Model'. I want
the 'Model' combo box to only populate with the models made by the
manufacturer selected in the first combo box. For example if manufacturer A
only makes models 1, 2, 3, and 4 but there are 30 models in total, how can I
get the second combo box to only display and thus save either 1, 2, 3 or 4.
if manufacturer A is selected. How can I do this please, I am not familiar
with VBA, although I would like to be!

 

[Cheese_whiz]

Hi Bob,

It's called "cascading combo boxes". Here's a link I got with a quick
search that's a bit old but still works and looks like something easy enough
to follow. If for some reason that doesn't work for you, search the forums
for "cascading combo box" or something like that.... It's a frequent
question so I'm sure you can round up all kinds of help with just one quick
search.

Hope that helps,
CW

 

[Bob Green]

Hi,CW
Thanks for the response. Sorry its took so long to thank you I am new to
this discussion group and still learning how to use it. I do not know if you
intended to add a link in your reply but I did not see one. I looked up
cascading combo boxes.