Cascading Combo Boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikeinohio - 29 May 2008 10:25 GMT

Hello I know i wasnt supposed ot post more thna once in different forums it
was a accident, please forgive me but anyways, I have 4 unbound combo boxes,
and they are named:

CboPatCity
CboPatState
CboPatZipcode
CboPatCounty

I have a table Called CSZ which have the following fields:
CSZID = Autonumber - PK
City = Text
State = Text
Zipcode = Text
County = Text

and my after update event is coded as follows:

Private Sub CboPatCity_AfterUpdate()
Me!CboPatCounty = Null
Me!CboPatCounty .Requery
Me!CboPatCity = Null
Me!CboPatCity .Requery
Me!CboPatZipcode = Null
Me!CboPatZipcode.Requery
End Sub

and what i need to do is to cascade these combos boxes to allow the
user to first select a city, then then next combo needs to show me all
states this city may be in, then after selecting the state the user needs
to select a county, the the appropriate zipcode, allthis is necessary
sice biling is driven by the clients state,citym county and zipcode.

I have tried every example i found on this site but none are seem to be
working.

what is it i am doing wrong?

Reply to this Message

Jeff Boyce - 29 May 2008 12:36 GMT

Have you checked at mvps.org/access, or searched on-line for "Cascading
comboboxes"?

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hello I know i wasnt supposed ot post more thna once in different forums it
> was a accident, please forgive me but anyways, I have 4 unbound combo boxes,
[quoted text clipped - 33 lines]
>
> what is it i am doing wrong?

Reply to this Message

mikeinohio - 29 May 2008 14:27 GMT

Yes was up til early morning looking i would get at most 3 out of 4 working
but not all, the one i was having the most trouble with was the zip code not
filtering right for a city like the one i live in has at least 15 zipcodes
and i would get all for my state, or the whole country.

Reply to this Message

ohlrichar - 08 Aug 2008 10:01 GMT

Did you ever get this working?

I am trying to use 3 combo boxes on my form and can only get two of them two
work.

If you were able to figure it out, could you please let me know how you did
it?

Thanks

> Yes was up til early morning looking i would get at most 3 out of 4 working
> but not all, the one i was having the most trouble with was the zip code not
[quoted text clipped - 38 lines]
> >
> > what is it i am doing wrong?

Reply to this Message