Limit selections in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database in Access 2000. I have a sub form with 2 combo boxes. The first lets you select a manufacturer name and stores the Manufacturer #. I want the second combo box to list the models for the manufacturer selected in the first combo box. I can do this by refrencing the manufacturer number on the form. It works fine for the first record you enter on the form but on the second and subsequent records entered the second combo box seems to be limited to information entered in the first record. How can I get around this
Rich
 
Take a look at the sample:

Data in a combo box control on a continuous form/datasheet disappears
http://www.fmsinc.com/free/tips.html#tip16foraccess

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
RDrake said:
I am working on a database in Access 2000. I have a sub form with 2 combo
Click to expand...
boxes. The first lets you select a manufacturer name and stores the
Manufacturer #. I want the second combo box to list the models for the
manufacturer selected in the first combo box. I can do this by refrencing
the manufacturer number on the form. It works fine for the first record you
enter on the form but on the second and subsequent records entered the
second combo box seems to be limited to information entered in the first
record. How can I get around this?
 
Back
Top