List of Choices

[Terrence H. Fountain]

I have 3 tables --

tblCounty tblCity tblAddress
fldCounty fldCounty fldCounty
fldCity fldCity
fldName
fldAddress ... etc.

tblCounty(fldCounty) creates the LIST BOX for fldCounty in tblCity and
tblAddress

tblCity(fldCity) create the LIST BOX for fldCity in tblAddress

What I want to do is when I enter information into tblAddress after I
enter in the value for fldCounty, I want the values for fldCity to be
only the values which are associated with the value of fldCounty in
tblCity.

I hope that made sense. Any assistance will be greatly appreciated.

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm