Double-action command boxes

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!
 

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