Save Record Question

[cpsqlrwn]

I have a form which only edits existing records. The last field is the only field available for editing and on the BeforeUpdate event for that field I have a vbYesNo confirmation box which is working properly. No closes the form without saving. Can someone provide me the code needed to save the record and leave the form open when Yes is selected? This form is cycling the current record only, not all records. Thank you.

 

[Eupher]

DoCmd.RunCommand acCmdSaveRecord

 

[cpsqlrwn]

I was able to save the record by putting the statement "Me.Dirty = False" in the AfterUpdate event for the editable field. Is there any potential problem with that or is that an ok alternative to your suggestion? Thank you!

 

[PHV]

'Me.Dirty = False' and 'DoCmd.RunCommand acCmdSaveRecord' have the same effect in a bound form.
I personally prefer the former (less typing ;-))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cpsqlrwn]

Thanks PHV!