drop down list boxes question

[Steve Goodrich]

I have a database with umpteen fields - two of them are for vehicles
details. At the moment you type the make in one field and the model in the
other. I would like to use fields with drop down lists so I could just
click to enter the details. I set up two tables, one for make and one for
model. this works ok but i would like to link the make to the model field.
eg when i enter the make as "FORD" only models made by ford are listed in
the "MODEL" field. The same way the Autotrader website works.

Is this possible to do without vb?
Any help would be appreciated

Steve

 

[AlCamp]

Steve,
(use your own names below)
In the query behind your cboModel combobox, include the Make column with
this criteria...
= Forms!frmYourFormName!cboMake
or...
= cboMake
That will filter out the cboModel combobox by the value of the cboMake.
hth
Al Camp