Limit list of combo box based on selection of another combo

[Guest]

I'm sure I'm making this entirely too difficult.

I would like to limit the list of one combo box based on the value chosen in
another combo. That would actually cascade on down.

Think of it like the first combo you select the state, then based on that
state, you see the counties in that state, then in the next combo box you
would see the cities/towns in that county for that state, blah blah blah.

I can't seem to figure this simple task out!

Thanks for your help!

 

[Guest]

I'm making a few assumptions that you have the combo boxes connected to a
lookup table, but the issue is having it be dependent upon another combo box.
On the combo boxes (which are dependent) on the OnEnter event, enter a
"Me.Requery" as this will repopulate the combo box with the new data (based
upon the prior combo box).

Let me know if a further explanation is needed or an example of the lookup.

SteveD

 

[Marshall Barton]

I'm sure I'm making this entirely too difficult.

I would like to limit the list of one combo box based on the value chosen in
another combo. That would actually cascade on down.

Think of it like the first combo you select the state, then based on that
state, you see the counties in that state, then in the next combo box you
would see the cities/towns in that county for that state, blah blah blah.

There's a short article on this atL
http://www.mvps.org/access/forms/frm0028.htm

See how far that gets you and come on back if you need more
help.