Combo Box?

[Brad]

I have created two combo boxes in a form that look up data
from two seperate tables and then add that info into a
third table.

What I want to happen is when I pick the item in Combo Box
1 I only want a certain set of data to show up in Combo
Box 2 that is associted to my choice from Combo Box 1. I
don't want Combo Box 2 to show everything.

Ex:

Table 1 Data
Car
Truck
SUV

Table 2 Data
Car Accord
Car Taurus
Car Camry
Truck F150
Truck Dakota
Truck Silverado
SUV Durango
SUV XTerra
SUV Trailblazer

So Combo Box 1 allows me to either pick Car, Truck or SUV
from Table 1. Then when I click on Car in Combo Box 1 I
only want Accord, Taurus, and Camry to show up in Combo
Box 2.

How do I do this?

 

[RobFMS]

You need to be careful about doing this. Take a look at this to help give
you an idea of what to expect.

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

--
Rob

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

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Steve Schapel]

Brad,

Use a query for the Row Source of Combobox 2, and in the criteria of the
VehicleType field in this query, you refer to the value of Combobox 1,
using syntax such as [Forms]![YourForm]![Combobox 1]