Save main form first

D

DCGirl

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

Any ideas are greatly appreciated. Thanks.
 
B

Brian Bastl

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
 
Top