need help designing an input form

[jimpeg]

I created a form to input data into a name&address Access database. What I would like to do is to be able to enter the zip code, then populate the city and state based on previous entries in the database. Right now, I have the city field set up as a drop-down box that contains cities previously entered (based on a query which groups by the cities). Any suggestions as to how I could go about it? If you know of a manual or book that talks about it, please let me know the name. Thanks, Jim

 

[TrainEase]

Jim

In the after update event in the postcode, set the adress fields using a dLookup back into the same fields in the same table, based on the postcodes being equal. If it finds one existing record with the same postcode it should fill the address fields. You will have to check the street number of course.

Alternatively - look at Quick Adress Pro - or similar - expensive though.

HTH

Regards, rob@trainease.com