There is another way
In the RowSource Property of the Model combo create the SQL that includes
the filter build in, in the sql
Select ModalField From ModalTable Where Make =
Forms![FormName]![MakeComboName]
On the after update event of the Make combo, write the code
Me.[ModalComboName].requery
"Ben04Ram" wrote:
i.e. In a database of cars, I want to create a form where the user selects a
"Make" of car from a drop-down box and then selects a "Model" from a
drop-down which *only contains the valid Models* for the currently selected
Make. There doesn't seem to be a good way of doing this except by using VB
and dynamically altering the filter of the "Model" drop-down whenever the
"Make" is changed.
|