Requery

[Guest]

Hello,

Quick question:

On my form I have a requery button to update information. When clicked, the
database go back to the first record. Is there a way that, after the requery
is clicked, it stays on the current record?

Thanks!!

 

[Guest]

Why do you save the record using Requery?

You can use

If Me.Dirty Then
Me.Dirty = False ' will save the record
End if

 

[Guest]

I wasn't intending to save it with the requery, after information was
inputted I just wanted to refresh the screen to show the updated dollar
amount not go back to the first record. What does "Dirty" do? Will that
refresh the current record and stay on the current record?

 

[Guest]

I tried it and it works great! This is exactly what I was looking for. Thank
you Ofer!!!!