Limiting field choices based on a previous field

[shaunism]

Hello,

I have some experience with Access, but only using the GUI - I cannot code the SQL myself.

With that said, here is what I am trying to build a form where the choices for one field are dependant on the previous field. For example, say I have colours available based on a car model:

Cars: SuperCar
DuperCar

SuperCar's available colours: Yellow
Red
Blue

DuperCar's available colours: Yellow
Green


Purple

So when I have a form, I want the two fields to be:

Car:
Colour:

But the options available in Colour depend on the Car that is chosen.

Cheers,
Shaun

[pbaldy]

A couple of ways:

Baldy-Cascading Combos

[shaunism]

A couple of ways:

Baldy-Cascading Combos

Thank you. Is there a way to do that with the GUI rather than SQL?

[pbaldy]

You can use a query built with the GUI for the first method.