Discussion Locked

Form Updating automatically in Access?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a generic database with two tables, two forms, and two querys! I have a contact table that stores all contact info like name,address,zip,phone,fax..etc... I have a table call postal code that has the city,state, zip in it. In my contact formyou fill in address and type in the zip it fill in the city and state. Now I have a button to add a new zip code from inside the contact form, but once you add the zip and close the mini zip form the main contact form does not recogized the new zip unless you close the main form and lose all the info about that contact!! I know theres a way to do this, Please help me... And Thank You in advance!! email for more questions

joshmiller@woh.rr.com
Joshua Miller

3 replies

by karpi

Hello,

I assume you use a combo-box for the zip-code.
After adding the zip code you have to requery the combo-box with code:
forms!MyMainForm!Combobox.requery

If you read the zip-code form a prebuild recordset you have to requery the recordset with

myRecordset.requery

HTH
Karpi

This discussion is closed to new replies.