Sub Lists with Drop Down Boxes

[STemplar]

I would like to change a database function but I am having trouble with the
process.

I have a list box that is used to select A Vehicle Make and the choices are
in a table called Vehicle Make.

I have another list box that is used to select the model of the vehicle.
This is also a list box and it's choices are located in the Vehicle Model
table.

After choosing the make of the vehicle the data entry person must then sift
through all the vehicle models that are loaded, not just the models for say
example Chevrolet. The list gives all models for all vehicle makes.

Is there a way to have the data show the models of vehicles only for the
make chosen. Eample: I choose Chevrolet as the Vehicle Maker, can I then
choose only from Chevrolet models?

Any help would be greatly appreciated.

 

[Jeff Boyce]

What you've done using ListBoxes is more-commonly handled with ComboBoxes.
What you want to be able to do is described as "Cascading Comboboxes" in
either HELP or via search.

You can use the same technique for your listboxes (basically, base the
second on a query that looks at the first for a criterion; in the
AfterUpdate of the first, requery the second).

That said, consider switching to comboboxes, as they take up a lot less room
on your screen.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[STemplar]

Thanks a bunch Jeff.

What you've done using ListBoxes is more-commonly handled with ComboBoxes.
What you want to be able to do is described as "Cascading Comboboxes" in
either HELP or via search.

You can use the same technique for your listboxes (basically, base the
second on a query that looks at the first for a criterion; in the
AfterUpdate of the first, requery the second).

That said, consider switching to comboboxes, as they take up a lot less room
on your screen.

Regards

Jeff Boyce
Microsoft Office/Access MVP