Is there any way to make it in the datasheet view of the table?
I usually enter the data in datasheet view and I don't make forms.

"Ofer" wrote:

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.