Record not being saved in the table after editing it

[akjandu]

I have a table called "Facility Information" and I have created a form based on that table. When I make any changes in the record by using form it does not save those changes in the table.
Record source for this form is "Facility Information" table.


None of the following methods solved the problem:

Using a built-in "Save" command of MS Access
Using VBA to open the record set and saving the information into the table.


Using VBA on close command i.e. (if the record is dirty..save it)

I have also run "compact and repair" operation to eliminate any kind of bugs that might be effecting my code.

Thanks in Advance

[JoeM]

Is it a native Access table, or linked from elsewhere?
If you try to make the exact same data edit to the table directly, does it work?

[akjandu]

It is a native table and yes if I make changes in the table directly, it gets saved.

[JoeM]

How exactly did you create the Form?
Check the Properties on the form and make sure it is set to allow edits.

You should not need to do anything to explicitly save the changes. They typically happen automatically, unless you have something like VBA code preventing that from happening.
The only other things I can think of is if your data entries violate some Data Validation rules, or if someone/something else already has that record open and locked, but you would get an error message if that happened.

You may want to try recreating the Form.
Just open your Table, go to the Create menu, and click Form.

[akjandu]

I created a new form as you suggested and did not change anything in the form properties. It saved the record for the first three time and stopped working after that. I have no validation rules on my table. There is no other user using this database. And the strange part is that forms saves some fields of the record.
Thank you so much for helping me.

[JoeM]

I think without seeing the database, and trying to do exactly the steps you are performing, it is going to be difficult to decipher. If you can upload a copy of the database, and give us an example of what to try that isn't working, we can see if we can see what is going on.

My only other thought is that is could be a corrupt database or Access install, in which case you would need to recreate the database (create a blank database and import all your old objects into it), or re-install Access and apply all patches and updates.