Entry choices dependant on another field entry

[BlackBooks]

How do I restrict the options in a lookup field to only those dependant on another fields data.



For example, say I had a field for "car make" and another for "car model" . If someone enters "Honda" For the "car make", I want to only be able to choose from a list of Honda models for the "car model" field. Similarly, if they choose "Ford" for car make, I want them to only be able to choose from a list of Ford models. How would I set this up?

[ranman256]

there's a little code to this.
the combo box cboModel query, gets its values from cboMake.
qsModels: select [model] from tCars where [make]=forms!myForm!cboMake

then when the user picks cboModel, you must refresh the cbo box in the afterupdate event:

sub cboMake_Afterupdate()
  cboModel.requery
end sub

set the combo box to LIMIT TO LIST = TRUE

[Missinglinq]

And FYI, for future reference, the concept is called Cascading Comboboxes...and the same concept/code can be used for Listboxes if the Multi-Select Property is set to None.

Linq ;0)>