M
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?
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?