Save the editing record!! 1

[Fekri]

Hi,

I have a bound form which I have a command button in it.
with this button user can open the new form with data based on first form.
now, if the first form when the record is new...
I have the
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
before open form command in button onclick event which will save the data in that record before open new form.
But if the first form opened in old record and user changed the some fields data, the above line will not help me to save the changes in record data before open the new form?

So, in this case, How should I prompt to save the current record with the changed data??

thanks
Fekri


Thanks & Good Luck
Ali Fekri

 

[PHV]

Replace this:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
with this:
Me.Dirty = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Fekri]

Thanks PHV

As God, you always getting my hand too tight.!!

thanks so much

Fekri

Thanks & Good Luck
Ali Fekri