Combo Box ? or Any other way to do this?

[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? Or is their a way to do this without
using combo boxes?

 

[Brendan Reynolds]

There's an example (in fact, two examples) at the following URL ...

http://www.mvps.org/access/forms/frm0028.htm

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[RobFMS]

Also be aware of this:

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

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