How populate state after entering a zip code

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
SteveL13Asked:
Who is Participating?
 
dustockConnect With a Mentor Commented:
Try the left function to only take the first 5 characters

Left(Me.txtZipCode,5)
0
All Courses

From novice to tech pro — start learning today.