Zip Code Problem

  • Thread starter Thread starter jwcrosby
  • Start date Start date
J

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?
 
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
 
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
Click to expand...

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.
 
Good point Armen.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top