drop down list boxes question

S

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Link a text box based on drop down box with four options MS Word 365 0
drop down box question 3
Drop down list control value in vba 2
Drop down lists in seperate columns 5
MS Project Center-Autolink column fields 0
Access 2000 Form design/combo box dilemma 4
limit the list of a combo box based on the result of another 5

Top