Requery in OnCurrent

  • Thread starter Thread starter peljo via AccessMonster.com
  • Start date 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?
 
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
 
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.
 
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
 
Back
Top