Aussiebear
12-31-2006, 07:04 PM
Is it better practise when using a start form to select subsequent forms, that you unload the initial form or just lose the focus of the initial form.
What I'd like to do is change to a new form and not have the old form still sitting in the background, but then on closing the second form, return to the initial form.
Code on the StartForm is
Option Explicit
Private Sub cmdDelivery_Click()
frmDelivery.Show
End Sub
Private Sub cmdTransfer_Click()
frmTransfer.Show
End Sub
Private Sub cmdClose_Click()
Unload Me ' for use in closing the form and moving to the sheets for data checks. Will be made a subterfuge close later on as project develops
End Sub
Private Sub cmdExit_Click()
This workbook.Close ' Save and Exit workbook
End Sub
When I bring up the secondary forms ( Deliveries & Transfers), I'd like the Startform to lose its visibility, and then on closing the secondary forms to be returned to the StartForm.
Example: FrmDelivery close button
Private Sub cmdClose_Click()
Unload Me
frmStartForm.Show
End Sub
Is this the correct method?
Ted
What I'd like to do is change to a new form and not have the old form still sitting in the background, but then on closing the second form, return to the initial form.
Code on the StartForm is
Option Explicit
Private Sub cmdDelivery_Click()
frmDelivery.Show
End Sub
Private Sub cmdTransfer_Click()
frmTransfer.Show
End Sub
Private Sub cmdClose_Click()
Unload Me ' for use in closing the form and moving to the sheets for data checks. Will be made a subterfuge close later on as project develops
End Sub
Private Sub cmdExit_Click()
This workbook.Close ' Save and Exit workbook
End Sub
When I bring up the secondary forms ( Deliveries & Transfers), I'd like the Startform to lose its visibility, and then on closing the secondary forms to be returned to the StartForm.
Example: FrmDelivery close button
Private Sub cmdClose_Click()
Unload Me
frmStartForm.Show
End Sub
Is this the correct method?
Ted