Requery in OnCurrent

  • Thread starter peljo via AccessMonster.com
  • Start date
P

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?
 
T

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
 
K

Klatuu

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.
 
R

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
 
Top