EMERGENCY: Requery (1 Viewer)

[k_heppner]

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

 

[Carol]

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