Double-action command boxes

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!

DoCmd.Close acForm, "frmFB001"

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200907/1

DoCmd.Close acForm, "frmFB001"

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com