Save main form first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to forcibly save the main form before
user clicks on the subform???

Any ideas are greatly appreciated. Thanks.
 
DCGirl,

Use the subform control's On Enter event procedure to test whether it is a
new record on the main form, since anything added to the main form will
automatically be saved when you move to the subform control:

Private Sub MySubform_Enter()
If Me.NewRecord Then 'disallow entry
Me.SomeControlOnMainForm.SetFocus
End If
End Sub


HTH,
Brian
 
Back
Top