If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Double-action command boxes
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 |
#3
|
|||
|
|||
Double-action command boxes
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 |
Thread Tools | |
Display Modes | |
|
|