Mutliple Drop Down Lists

[padders01]

Hi All,

I have an Access Database with lists of cars, the fields are (ID, Make, Model, Price)

I would like to create a drop down list that when the user selects Ford for example it lists all the different models for a Ford only then a price which will all be stored in the database

Can this be done?

Thanks in advance

[rupali]

Hi padders01,
Please can you elaborate a bit in detail.