Values drop during requery

[Guest]

Hi all,

I know this is probably being a bit picky, but has anyone found out a way of
stopping the values in a form dissapearing during a requery?

TIA

 

[Allen Browne]

A Requery causes the form to reload all its records. It is going to pass
through a moment when there are no records, as they all get loaded again.
And it is going to revert to the first record in the form (or the new record
if opened in Data Entry mode.)

If you are talking about not seeing something, you might want to try turning
Echo Off before the requery, and on again afterwards.

If you are talking about not going back to the first record, you will need
to save the primary key value into a variable before Requery, and then
FindFirst in the form's RecordsetClone and set the Bookmark afterwards.

If you are talking about not having the records you just entered disappear
in Data Entry mode when you requery, you are out of luck.