Subform Wants Main Form Record Updated First

Thanks. I do not think the record save is automatically happening when I
leave the main form. Please excuse my ignorance, but, where do I put the
beforeupdate event and how should it be written.

"ruralguy via AccessMonster.com" wrote:

You are correct here. You would use the BeforeUpdate event to verify that
*all* of the fields are completed properly. Otherwise set Cancel = True to
hold the user in the MainForm until it is properly completed or use Me.UnDo
to remove any changes to the form.

ridgerunner wrote:
I think I need to be certain when the save should take place. I am thinking
that once I enter the data on the main form and move to the subform that the
record in underlying table for the main form should automatically be saved.
Is this correct? Is there a property setting I need to check? Thanks for
your help.

If you have any code, anywhere in your database, which reads:

[quoted text clipped - 76 lines]
do
I solve this?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

I just set up a simple simulation on my machine at home and the subform and
form work like they are expected. There must be something out of order with
the working database and tables I have been setting up. Thanks for your
advice and patience.
ridgerunner

"ridgerunner" wrote:

Thanks. I do not think the record save is automatically happening when I
leave the main form. Please excuse my ignorance, but, where do I put the
beforeupdate event and how should it be written.

"ruralguy via AccessMonster.com" wrote:

You are correct here. You would use the BeforeUpdate event to verify that
*all* of the fields are completed properly. Otherwise set Cancel = True to
hold the user in the MainForm until it is properly completed or use Me.UnDo
to remove any changes to the form.

ridgerunner wrote:
I think I need to be certain when the save should take place. I am thinking
that once I enter the data on the main form and move to the subform that the
record in underlying table for the main form should automatically be saved.
Is this correct? Is there a property setting I need to check? Thanks for
your help.

If you have any code, anywhere in your database, which reads:

[quoted text clipped - 76 lines]
do
I solve this?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1