Refresh form data

rmunteanu

Radu from SOMACO
Local time
Today, 11:54
Joined
Jul 21, 2009
Messages
12
Hi,
I am working in Acces 2007. I added a "refresh form data" command in a form on a Combo Box control on "Got focus". I did this to automatically refresh data in the Combo Box list after adding new data. The problem is i have some fields that are marked "required" and the form does not refresh because the table does not accept the new record where required field is missing. So I get an error message.
Can you give me an advice?
Thanks
 
You can either remove the requirements from the fields at the table design level, or you can trap the error by validating all the data before saving a new record. It all depends on your data model and business rules.
 
Also, some important info (from the Access help file) that you should know about Radu -
Access help file said:
If you are using a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.), or a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records.

In an Access database (.mdb), refreshing records only updates the data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, requery the records.
 

Users who are viewing this thread

Back
Top Bottom