How to show only specific records based on data chosen in other field.

[SuperSchnauzer]

I wasn't really sure how to describe this so didn't have much luck googling. Anyway, I'll come up with an example of what I want to do and hopefully it's something easy.

Let's say I have a form whose table contains information about hundreds of vehicles. I want to categorize these vehicles based on type and model.

so I have a table "Class" that only contains records like Car, Train, Plane, Boat, etc. Let's call this field "Type"

Now I have another table for "Vehicle Type" that contains 2 fields - "Type" and "Model".

It would look a bit like this:

Type, Model
Car, widget
Car, hyundai
Car, ford
Boat, widget
Boat, yacht


Train, amtrak
Plane, NYC subway

On this form I'm working on, I want it so that if a user adds a new record and categorizes it as a "Car", when they choose what Model it is, they are only presented with the choices of Widget, Hyundai, or Ford. If they choose something like "Boat" instead, they still see widget, but now yacht, and no other choices.

so I think I have to adjust the row source but am not sure if I need to build a query and how I would even input the row source. I don't really have any ideas.


Does anyone know what I'm talking about.

Any help would be appreciated! Thanks

[pbaldy]

How about:

http://www.baldyweb.com/CascadingCombo.htm

[SuperSchnauzer]

Don't know if I understand either explanantion.

"One is to have the row source of the second combo refer to
the first in its criteria, then requery the second combo in the After Update
event of the first. The code would look like this:

Me.cboCities1 = vbNullString 'to clear the second
combo
Me.cboCities1.Requery"


specifically the bold faced part. Yes, I have two combo boxes, but don't really know where and how to define the critera.

[pbaldy]

Did you look at the sample db?

[SuperSchnauzer]

Did you look at the sample db?

missed that...sorry. I'm good now! thanks!

[pbaldy]

Happy to help!