L
laura.dodge
Hi, I'm trying to make a form for a data entry of a very large survey.
I have multiple tables because there are so many questions, and after
having much trouble adding skip patterns on my tabbed subforms, I am
trying a different tactic. My plan now is to have multiple forms so
that the skip patterns will work. I'll add command buttons to each of
the forms so the user can move to the next form when they are finished
with the current one. I used the command button wizard, which worked
well, but then I realized that I want the completed form to close when
the new form is opened. I looked at some other boards and it seems
like it's easy to do, but I'm still having trouble. I don't know VBA
well, but here's what I have in the code window:
Option Compare Database
Private Sub cmdFB001_Click()
DoCmd.OpenForm "frmFB212a"
DoCmd.Close "frmFB001" (I also tried Me.frmFB001)
End Sub
Based on what I've seen on other discussions, this should work? When
the button is clicked I want the form frmFB001 to close and the form
frmFB212a to open. Can anyone tell me if I'm missing something? Thanks
so much!
I have multiple tables because there are so many questions, and after
having much trouble adding skip patterns on my tabbed subforms, I am
trying a different tactic. My plan now is to have multiple forms so
that the skip patterns will work. I'll add command buttons to each of
the forms so the user can move to the next form when they are finished
with the current one. I used the command button wizard, which worked
well, but then I realized that I want the completed form to close when
the new form is opened. I looked at some other boards and it seems
like it's easy to do, but I'm still having trouble. I don't know VBA
well, but here's what I have in the code window:
Option Compare Database
Private Sub cmdFB001_Click()
DoCmd.OpenForm "frmFB212a"
DoCmd.Close "frmFB001" (I also tried Me.frmFB001)
End Sub
Based on what I've seen on other discussions, this should work? When
the button is clicked I want the form frmFB001 to close and the form
frmFB212a to open. Can anyone tell me if I'm missing something? Thanks
so much!