record

  • Thread starter Thread starter bisha
  • Start date Start date
B

bisha

I have a form and a subform inside it.
I need to cancel the current record from the main form if
the user tries to close the form without entering anything
in the subform.
 
Unfortunately, it might not be possible since as soon as the user moves to
the Subform (prior to entering anything in the Subform), the Record in the
main Form is updated into the Table. This is known as the AutoSave feature
of the Form/Subform combination.

Note that the Form/Subform combination is designed mainly for Tables in
One-to-Many relationship and the AutoSave feature is designed to enforce the
Referential Integrity of this relationship (the Parent / "One" Record *must
exist* before the Child / "Many" Records and it is possible to have Parents
*without* Children).

There is no way you can disable this AutoSave feature. There are
work-arounds but they are all messy and involve a fair bit of VBA coding.
 
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

First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Saving a record in subform 5
Set focus in a specific record within a subform 1
data entry in subform before mainform causes huge hassle, HELP! 2
Trouble associating parent form record to subform's record 1
BeforeUpdate doesn't always fire 15
Access Main form/Subform Navigation 0

Back
Top