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?