Zip Code Problem

[jwcrosby]

I know the routine for entering a zip and having it "find"
the appropriate city and state from a separate table.
That's the easy part.

But how do you handle the fact that some zip codes are
assigned to more than one city? For instance, Amherst,
Pelham, Cushman and South Amherst, Mass. all have the same
zip code (i.e., 01002).

So, if I'm entering a person's data and plug in "01002"
for his zip code, but it finds the wrong city, what are my
options?

Suggestions?

 

[Adrian Jansen]

Make a query 'on the fly' filtered on the zip code you selected, then use it
as the recordsource for a combo or list box. The user then sees just the
few cities that match, and is prompted to select the correct one.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Armen Stein]

Make a query 'on the fly' filtered on the zip code you selected, then use it
as the recordsource for a combo or list box. The user then sees just the
few cities that match, and is prompted to select the correct one.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

And to save them time, you can default in the City if only one matches,
as most will. Just make them choose one if more than one city matches.

 

[Adrian Jansen]

Good point Armen.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control