Search results

Thanks Paul, I have seen this link earlier when I was trying to get a solution.. Please bare with me, I tried the code below, Private Sub zip_AfterUpdate() Dim varState, varCity As Variant varState = DLookup("State", "zipcodes", "zip =[Zip] ") varCity = DLookup("City", "zipcodes", "zip =[Zip]...

I have a Zipcode database which I imported in the Northwind database Access template. I have been looking for a solution where in forms such as "Suppliers" "Customers" "Users" the contact information forms to fill the City and State when user inputs the zip code in "Zip Code/Postal Zone" box...