saving data in a subform

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

Guest

How do I save the data in a subform without closing the main form and without
moving to another record in the main form?
 
Jason said:
How do I save the data in a subform without closing the main form and
without
moving to another record in the main form?
Click to expand...

Me.SubformControlName.Form.Dirty = False
 
Jason said:
How do I save the data in a subform without closing the main form and without
moving to another record in the main form?
Click to expand...


Any changes to a bound subform's data will be saved
automatically when the focus moves to the main form.

The same is true when you navigate from one record to
another within the subform.

If you want to use a button (or some some other action
within the subform, then use:
Me.Dirty = False
 

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

How to detect navigation 5
New records don't display correctly in subforms after save. 1
subform based on external SQL won't requery 1
Subforms won't refresh after new record 3
Error -2147352567 (80020009), Access 2007 0
Avoid Saving a Record 2
Refresh data in sub forms when one sub form is edited 4
Passing a value from subform or main form to subform query 4

Back
Top