Hi

I need to know the answer to this one today.. ASAP if possible.

When I change a value in a field, I want the whole form requeried. If I put in Me.Requery it does the Requery, but always displays the data for the first record. Is there any way to specify it to do a requery, but show the data for the record that was displayed before the Requery ran?

Thanks!
k_heppner

Open your form in design view and open the properties box. Go to the Cycle line and select Current Record. That will produce the result that you want.
Good luck