Disappearing records in datasheet view

R

RipperT

I have a subform in datasheet view into which users enter a value in a
single field for each record. There are other fields but they are filled
automatically and are locked. Users complaining that after entry of 10-20
records, the records disappear from the screen and the datasheet returns to
a state like they just opened it - with just the first empty row appearing
ready for entry. Investigation reveals that the records entered up to the
disappearance are recorded in the DB, they just aren't visible on the
datasheet anymore. Checked for scroll bars and data out of sheet range -
nothing there. The form's data entry property is set to true. I put .Repaint
in the field's afterupdate event - no help. This just started happening
recently after several years of no problems. Anyone know what gives?

Thank you,
Ripper
 
R

RipperT

I only want the form to show the records for the current session. Once the
user closes the form, I don't want previously entered records showing. But I
do want records entered in the current session to show, but they are
disappearing without the form being closed.

Rip
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top