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

  • Thread starter Thread starter zawanda
  • Start date Start date
Z

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
 
zawanda said:
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
Click to expand...


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

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