Sub data lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

STemplar - 02 Jan 2008 22:49 GMT

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.

Reply to this Message

John W. Vinson - 03 Jan 2008 00:49 GMT

>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]

Reply to this Message