Sub data lists

[STemplar]

I have created a combo box for a report. The combo box is Vehicle Make. I
would like to be able to choose a make, for example Ford and have another box
pop up with only Ford models. I currently have two combo boxes, one for
Vehicle Makes and one for Vehicle Models. Can anyone help? Thanks in advance.

 

[John W. Vinson]

I have created a combo box for a report. The combo box is Vehicle Make. I
would like to be able to choose a make, for example Ford and have another box
pop up with only Ford models. I currently have two combo boxes, one for
Vehicle Makes and one for Vehicle Models. Can anyone help? Thanks in advance.

This is a very common requirement, "Cascading Combos".

Base the Model combo box on a query referencing the Make combo box, basing it
on a query with a criterion such as

=[Forms]![YourFormName]![cboMake]

assuming cboMake is the name of the combo box (don't use blanks in control
names, it's a hassle).

You'll need to Requery the model combo in the afterupdate event of the Make
combo.

John W. Vinson [MVP]