Creating Lookup Fields

[Kevin R. Norton]

I have a database where I want to have the lookup fields cascade. A good
example of this is when you visit an automotive parts website. You first
enter the year of your vehicle, then the next field (Vehicle Make) lists
vehicles from that year, then the next field (Vehicle model) lists the models
of that vehicle make.

My database is going to track tech calls and I want to make the process as
smooth and quick as possible. The use of drop-down lists (using a seperate
table for the lookup) that would cascade like described would allow for quick
entering of fault codes.

 

[John W. Vinson]

On Wed, 6 Feb 2008 14:28:01 -0800, Kevin R. Norton <Kevin R.

I have a database where I want to have the lookup fields cascade.

If you're using table lookup fields, you can't.

If you (properly) use Forms to interact with the data, it's easy. Base the
dependent combo box on a Query referencing the controlling combo box as a
criterion - e.g.

=Forms!SomeFormName!SomeComboName

on the criteria line; and requery the dependent combo in the Afterupdate event
of the controlling combo.

John W. Vinson [MVP]