Cascading Combo Boxes

[mikeinohio]

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?

 

[Jeff Boyce]

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

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

 

[mikeinohio]

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.

 

[ohlrichar]

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