Response of drop-down one change the options of drop-down two

[Mike]

I have a form with multiple drop-down boxes. All of which pull their
information from an access dbase.

How can I make it so that when the user selects an item in drop-down one,
drop-down two changes?

Example:

Drop-down one Options:
Car
Truck
Motorcycle

Drop-down two options:
If Car
Accord
Camry
Jetta
etc...

If Truck
Ford Superduty
Ford F-150
Chevy S-10
etc....

Mikeal

 

[Kathleen Anderson [MVP - FP]]

How to filter a database query using two drop down lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

 

[Mike]

Kathleen,

How can I do it without a submit button?

Mikeal

 

[Jon Spivey]

Mike,
I haven't tried Kathleenn's technique but from reading through it you should
just need to delete the submit button from your form then locate your select
tag and modify it thus
<select onchange="this.form.submit();".......