Solved

How populate state after entering a zip code

Posted on 2014-03-19
1
229 Views
Last Modified: 2014-03-19
I have a zipcode table setup which contains just the 5 digit zip code.  But we are going to enter the Zip +4 in a field.  For the afterupdate event of the zip code field I have this:

   txtState = DLookup("State", "tblZipCodeDirectory", "ZipCode = " & Me.txtZipCode)

But we're entering the zip +4 data in the first field.  How do I ignore the +4 part of it to do the DLookup?

--Steve
0
Comment
Question by:SteveL13
1 Comment
 
LVL 9

Accepted Solution

by:
dustock earned 500 total points
ID: 39939866
Try the left function to only take the first 5 characters

Left(Me.txtZipCode,5)
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Create a EXCEL FIle from Access Procedure 1 19
Calculation in Access 5 26
DCount Type Mismatch 2 22
Sum with where criteria on a report 5 16
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question