Update screen with requery

[Duncaninnz]

I have a multiuser datasheet view screen that I have set to requery on any
entry or modification of data. I have overcome the problem with cursor
position using bookmark. However the screen repositions itself so that the
last modified or entered record is at the very bottom of the screen after
requery. This is hopeless from a user point of view as when you modify the
record in the middle of the screen and say click down one to modify another
it shunts the whole screen down. Any suggestions would be greatfully received.

 

[Nikos Yannacopoulos]

Use sorting on an appropriate field to make sure the record order
doesn't change.

HTH,
Nikos