Disappearing Info in Forms

N

new2access

I entered info into specific fields in a form. I closed the form. When I
reopened the form, the info I entered was not there.
 
J

John W. Vinson

On Mon, 5 Feb 2007 16:14:00 -0800,
[email protected]
I entered info into specific fields in a form. I closed the form. When I
reopened the form, the info I entered was not there.

That suggests that there's something wrong with the form (which, of
course, we cannot see).

Are the Controls (tables have fields, forms have controls) that are
showing this behavior bound to table fields? Is the information
getting into the table? Bear in mind that Forms are JUST windows and
don't contain any data!

John W. Vinson [MVP]
 
R

Ron2006

On the data tab of the form properties does it say DataEntry = Yes.

If that is true then it is in add mode and will NOT show existing
records. To see prior records and be able to add records you must say
DataEntry = No and AllowAdditions = Yes.

Ron
 
K

kincaidch

I am experiencing a similar problem. We use a multiple user database and
occasionally a user will enter in a date, tab to the next record or close the
form completely, then go back to the edited record and the date they just
entered won't be there. This doesn't happen all the time, only occasionally.
Any ideas on what could be causing this would be greatly appreciated.
 
R

Ron2006

On the surface it would seem that multiuser is not the problem because
you should be getting a error message if two people were trying to
update the same record.

On the missing update, Is there ANY chance that the person pressed
the <ESC> key in the process of trying to tab forward.
A single ESC will undo changes to the field you are in, and two ESC
will undo ALL changes to that record.

The only sometimes is the part that makes it difficult to deduce a
pattern simply because it is not apparent.

Ron
 
K

kincaidch

I can't say for other users but the disappearing data has happened to me
several times and I always either tab or use my mouse scroll to move to the
next record when I have made a change.
 
Top