Smarter than your average combo box (1 Viewer)

[dynamictiger]

I have a form with a combo box to look up suburbs.

To speed up form loading we limit the suburb by state intially to limit the length of list.

The problem is that when the user wants to enter a different suburb from another state, how do we requery the combo box and move on with the new data already correctly located?

 

[dcx693]

Why not have two combo boxes, where the first selects the state and the second the suburb from the suburbs within that state?

 

[maxmangion]

you can use the onChange event and put Me.ComboBoxName.Requery