Passing Criteria From a Form

  • Thread starter Thread starter Kevin D.
  • Start date Start date
K

Kevin D.

I have a Query named qryZipCode based on tblZipCodes which looks up the City
and State for a certain Zip Code. The criteria for the "ZipCode" field is
passed from frmAttendeesAll using the following:
[Forms]![frmAttendeesAll]![Zip]. Is there a way to code the criteria to only
consider the first 5 digits passed for the zip code from the form, such that
if the zip code passed is 12208-2115, the query would only use 12208 for the
criteria?

Thanks in advance for your help.

Kevin D>
 
Back
Top