Automatically Update a Record

[AussieNerida via AccessMonster.com]

Hi there,

I have a form that requires users to enter data, then click a button that
opens another form that needs that data to be saved before the linked form is
opened. If they don't save the record the form that opens has a whole bunch
of blank fields. I am struggling with the code that will allows the record
to be automatically saved when they click on the button that opens the
related form.

I am using the AfterUpdate event and have tried a macro to save the table but
this doesn't work . Can anyone help me with the code to update the record?
I'm sure it's dead simple but I just don't know VBA well enough.

Any help much appreciated.

Many thanks,
Nerida.

 

[Allen Browne]

You can save the record with:
Me.Dirty = False

Other alternatives:
RunCommand acCmdSaveRecord
Me.Refresh
and so on.

 

[AussieNerida via AccessMonster.com]

Thanks Allen, works a treat.

Cheers,
Nerida.

You can save the record with:
Me.Dirty = False

Other alternatives:
RunCommand acCmdSaveRecord
Me.Refresh
and so on.

I have a form that requires users to enter data, then click a button that
opens another form that needs that data to be saved before the linked form

[quoted text clipped - 11 lines]

record?
I'm sure it's dead simple but I just don't know VBA well enough.