Disappearing data...

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

In a form (it worked fine for 8 months) the entered data
disappears when moving to a different record. I am able
to enter the data into the table itself and it stays. I
also created a new form and it also disappears. Working
with Access97 in a Windows 2000 environment.

Any advice would be great.
Eric
 
Eric said:
In a form (it worked fine for 8 months) the entered data
disappears when moving to a different record. I am able
to enter the data into the table itself and it stays. I
also created a new form and it also disappears. Working
with Access97 in a Windows 2000 environment.
Click to expand...

Do you have the form's DataEntry property turned on? In that case the form only
shows records entered in the current session. It doesn't display previously entered
records, but they are still in the table.
 
-----Original Message-----


Do you have the form's DataEntry property turned on? In that case the form only
shows records entered in the current session. It doesn't display previously entered
records, but they are still in the table.


.
I found out the problem...the combo box was actually
Click to expand...
maxed out. It was not pulling the correct record. I will
rewrite the lookup via VB. Meanwhile, the 'find' (CTRL F)
function works fine.

Thanks for your thoughts.
 
Back
Top