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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Main form/Subform Navigation 0
calculated control event order 2
How to detect navigation 5
Access Sub form opens before the main form in MS Access 0
setting recordset when switching from subform to main form 3
Calculated control event order 2
showing a subform based on the main form 5
Another Question on Subforms 2

Back
Top