how can I loop commandbuttons?

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

Guest

CommandButton:
opensquery1offhold
Msgbox to abort
If vbNo
prints report for results of query1offhold
Msgbox to abort
If vbNo
openquery2 onhold,acnorm,acEdit


Now I want to loopback to the top.......how?
 
How many times do you want to loop back to the top, and why?
=================================================
You can use something like

Dim I As Integer
For I = 1 to 5 ' will loop 5 times
opensquery1offhold
Msgbox to abort
If vbNo
prints report for results of query1offhold
Msgbox to abort
If vbNo
openquery2 onhold,acnorm,acEdit
Next I
 
Back
Top