I have a form that has two controls, vehicle make and vehicle model.  The 

source for both controls is a lookup list on table, you guessed it, tbl 

makes and model  that has three fields, ID, Vehicle make and Vehicle 

model.  I want to limit the list of vehicle models to those that coincide 

with a particular make, IE  chevrolete in make field limits model choices 

to corvette, astro, ect.  How do I do this.   



It seems that I could make the model field's source a query but how do I 

pass the previous fields data as a parameter?  Very new at coding, so 

write slowly K?



-N-

Check out the HELP for the Filter property on the vehicle model control.

Use the ON UPDATE feature of the vehicle make control to update 

the .Filter property of the vehicle model control, then refresh/requery 

the control.

... AL





> I have a form that has two controls, vehicle make and vehicle model.  

The 

> source for both controls is a lookup list on table, you guessed it, tbl 

> makes and model  that has three fields, ID, Vehicle make and Vehicle 

> model.  I want to limit the list of vehicle models to those that 

coincide 

> with a particular make, IE  chevrolete in make field limits model 

choices 

> to corvette, astro, ect.  How do I do this.   

> 

> It seems that I could make the model field's source a query but how do I 

> pass the previous fields data as a parameter?  Very new at coding, so 

> write slowly K?

> 

> -N-