Recent content by TomPollock

OK I got it working great!!!! When I typed in Beforeupdate I miss named the zipcode field Zip it should have been ZIPCODE as that is what it is in the ZipCode table. Thanks every one for your help to this stage. Many Thanks Tom

I can see what is happening. When I fill in the zip field and click enter. The zip field retains the zipcode I entered but fills in the City and State from the first row of the Zipcode Table. Yes I do need the zip fields to be in Text format as in the practice table I have only six citys...

I had changed both to a numeric field when it first gave this problem. I just changed changed Zip in both tables back to Text and tryed again and still get the worng City and State. I feel I'm so close!!!!! Thanks Tom

Hi I have tryed both methods and seem to get the closest to what I want with donbettis method useing DLooup. This is what I entered in the before up date event. Private Sub ZIP_BeforeUpdate(Cancel As Integer) City = DLookup("[City]", "ZipCode", "[Zip]= '" & Me!ZIP & "'") State =...

Thanks I will work with that and let you know how I made out.

I am looking to make a data base to register contestants for a prize contest. We register from 400 to 10,000 contestants over a couple of months and then start with a new contest and new restrations. I have a table with all the US postal codes called zipcodes (5 didget numbers (59401)but will...