using one combo box to determine content of a second combo box

[zawanda]

Hello,

I have been trying for several days to figure out how to use one combo
box to determine the content of a second combo box.

I am creating a database listing equipment by manufacturer and model #

I would like to create one combo box that gives a drop down list of
manufacturers

Then, based on the manufacturer chosen, I would like to have a second
combo box which gives a drop down list of model #'s offered by the
chosen manufacturer

It seems like a fairly simple concept, but I have poured through the
"using access 2003" guide with no luck

Access version I'm using: 2003

 

[Marshall Barton]

I have been trying for several days to figure out how to use one combo
box to determine the content of a second combo box.

I am creating a database listing equipment by manufacturer and model #

I would like to create one combo box that gives a drop down list of
manufacturers

Then, based on the manufacturer chosen, I would like to have a second
combo box which gives a drop down list of model #'s offered by the
chosen manufacturer

It seems like a fairly simple concept, but I have poured through the
"using access 2003" guide with no luck

Access version I'm using: 2003

Here's an article that demonstrates how to fo that:
http://www.mvps.org/access/forms/frm0028.htm

 

[zawanda]

Marshall,

Thank you very much. It's working now, thanks to your's and Tina's
help. Thanks again!