Combobox Value Based Display

[MCCDOM]

Hi there,

I am looking to create a combobox that will show only specific results based upon the previous combobox selection. Now I know this can be done using two separate tables i.e one for make and one for model but I have one form with both make and model and wanted to keep it that way. So how would I go about getting cboModel to show only the specific models that relate to the make selection in cboMake?

Look forward to your suggestions.

Many Thanks



Dom

[pbaldy]

I don't see how it matters how many tables are involved, you simply need to use the first combo to filter the second, using SQL appropriate to your table structure.

Baldy-Cascading Combos