run a macro when a control reaches certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form to update records. For each record that has been processed I
increase the value of a counter. After the counter reaches 100 I want to run
a Macro that displays a Batch ID and resets the counter to start over. Is
there some way I can run the Macro based on the value of the counter?
 
Back
Top