Newbie Assistance

[subzero569]

This site is great. I have made my first attempt at database creation. I used the standard contact management database from access as a template.

Numerous threads were beneficial in working out problems in my database. I added a zipcode autopopulate combo box which was a major problem I encountered in this process.

Anyways, the problem is with the autopopulate for the zipcode. The form fills in the city, state and zipcode form fields without trouble. But, the table is not updated with the city, state or zipcode. (Zipcode database is a separate table from contacts table)

Any thoughts? Also, this is a database for personal use in my small family business. Also, does anyone have the time to take a look at the database and offer assistance in smooting out the rough edges? Is this an acceptable question in this forum?

Thanks,

Subzero569

 

[Navyguy]

Hi there

I was just wondering why, if you have all the city, state and zip information saved that you would want to save it again, that is of course the zipcode table is located in a totally separate DB and not just a separate table within the DB. (I wasn't quite sure what you ment). You don't want to save information twice (normalization).

As far as saving your info, it would seem like your form is setup for data entry and is not properly linked to your tblPeopleContacts. There are several ways to do this, but they all are related to you Record Source of your form, whether it be from a qry,tbl etc.

Check the properties of your entire form and see where they are pointing to.

Hope I have helped and not confused you...

 

[subzero569]

Thanks

Thanks for the assistance NavyGuy. The zipcode, city, state and county are a separate table in the database. It was a program I found listing all zipcodes for US. I guess I just have everything structured incorrectly. That is part of learning.

Let me verify some items and I will get back to the forum with more questions.

Thanks