I have a form wilth multiple buttons Forms!frm_Vacation!Button1_R1 through Forms!frm_Vacation!Button5_R9 (Five rows of 9 buttons.)
I want to do a for loop and pull he value from each of the buttons.
How do I change the 1 on Button and the 1 on R to be a different value each time through the for loop?
for i=1 to 5
for x=0 to 9
if "Forms!frm_Vacation!Button" & i & "_R" & x & ".Caption" = 3 then