Linked combo box problem. 1

[Migman01]

I need 2 combo boxes called 'Car Make'(e.g Ford) and 'Model (e.g Fiesta), the problem is that I need the Model combo box to only display the models for the Car Make selected, for example: If the user selects Ford as the Car Make, the model combo box should then only display the Ford models for selection. Knowing how to structure my tables/queries will help.

This is probably very simple to do, but i'm new to the database stuff.

Thanks.

 

[fneily]

You probably have a table with fields [Car Make] and [Model].

On the Rowsource options of your comboboxes, you'll have something like:

SELECT DISTINCT [Car Make] FROM TableName WHERE [Car Make] is not null;

SELECT DISTINCT [Model] FROM TableName WHERE Model Is Not Null And city=Screen.Activeform![Car Make];

Then on the AfterUpdate event of your first combobox, you'll have something like:

Private Sub city_AfterUpdate()
Me![Model].Requery
Me![Model].SetFocus
Me![Model].Dropdown
End Sub

Substitute Table names and field names where appropriate.

 

[Migman01]

Thanks a lot, fneily, that has helped me fix the problem