run a macro when a control reaches certain value

E

Elise

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top