A andrew v via AccessMonster.com Mar 23, 2005 #1 pretty novice to the VB side of it. but, how do i close the current form once i've clicked on a button to go to a new form? thanks...
pretty novice to the VB side of it. but, how do i close the current form once i've clicked on a button to go to a new form? thanks...
J Jeff Conrad Mar 23, 2005 #2 Something like so: Private Sub cmdOpenCloseForms_Click() DoCmd.OpenForm "NameOfOtherFormHere" DoCmd.Close acForm, "NameOfThisFormHere" End Sub For the second line you could also use Me.Name for the current form, but I prefer to specifically tell Access what object I want to close.
Something like so: Private Sub cmdOpenCloseForms_Click() DoCmd.OpenForm "NameOfOtherFormHere" DoCmd.Close acForm, "NameOfThisFormHere" End Sub For the second line you could also use Me.Name for the current form, but I prefer to specifically tell Access what object I want to close.