Requery in OnCurrent

[peljo via AccessMonster.com]

I want to perform a requery in the OnCurrent event only in case the Command
button called "Back" is not pressed.if the command button is pressed, the
requuery should not be carried out.How could i do that?

 

[TC]

You should not perform a requery from within the Current event. The
requery will eventually cause another Current event to occur. What
happens then?!

What are you actually trying to achieve?

TC (MVP Access)
http://tc2.atspace.com

 

[Guest]

TC is correct. A requery in the Current event would not only cause the
Current event to fire repeatedly, it would reposition your recordset to the
first record every time it fired.

 

[Ron2005]

requery of what?

Requery of another subform would be on the oncurrent if the subform to
subform relationship was not a parent child relationship.

Ron