Microsoft Access form controls not updating after table changes

If updates to the underlying table in Microsoft Access are not being reflected in your bound form controls, there are a few troubleshooting steps you can consider:

1. Requery the Form: Instead of just refreshing, you might want to use the Requery method on the form. This will refresh the entire record set and should reflect any changes made to the underlying table.
2. Check for Locking Issues: If another user has the record locked, you may not see the updates until the record is unlocked. Ensure that no other users are editing the same records.
3. Verify Record Source: Make sure that the record source of your form is correctly set to the table or query you are trying to update. If the record source is incorrect, it may not reflect the changes.
4. Check for Read-Only Conditions: Ensure that the database is not opened in read-only mode and that the underlying table is not located on a read-only drive. If it is, you will not be able to see updates.
5. Use the RefreshRecord Action: If you are using a macro, consider using the RefreshRecord action to update the underlying record source for the active form or datasheet to reflect changes made to the records in the current set.
6. Database Corruption: If the problem persists, there might be a corruption in the database. Compacting and repairing the database can sometimes resolve these issues.

If none of these solutions work, consider checking for any specific error messages or conditions that might be affecting the update process.

References:

• How to troubleshoot errors that may occur when you update data in Access queries and forms

Hi,

1. Are form and underlying table in the same database file or is the table linked?
2. If the table is linked, is it an Access table or in/from a different system?
3. What does the record source look like? Just the table name or a query/SQL? Can you post it?
4. Could there be programming involved that affects the connection to the data or display of the data?
5. What kind of form is it? Single, continuous, split...?
6. Does "some fields still show outdated values or stay blank" refer to a specific record or does it happen to all records that have been changed in the table?

Servus
Karl

Access Forever News DevCon
Access-Entwickler-Konferenz AEK

How exactly are you updating the underlying table? Why aren't you using the form itself to update the table? Just curious...