Based upon your last comment, you seem to be saying during a session you make record changes and can go back and see them. Once you close the form and re-open the changes are gone.
When you re-open the form and the changes seem to be gone have you looked at the actual table entries to see if they are there? If they are there, are you just going by the record number in the navigation bar? If the record bar shows 1 of 41*
the *
means there are more records and only 41 were loaded into memory. Clicking the Last Record
button on the navigator will load all the records.
If you don’t find the changes in the tables themselves, you must be doing something with macros that affect the data. If so, a complete sample (without personal or confidential information) is necessary to determine what is going on.