Me.Dirty = True to capture default values

[philbullock1223]

I have a very simple form where I would like the user to have the option of accepting all the default values on the form.

This is causing me a problem because if the user wants to accept the default values, he will hit "OK" however the record is not saved because the form was not dirty.

Inside the "OK" button I have tried code:

Me.AnyBox.Value = Me.AnyBox.Value
DoCmd.Save
DoCmd.Close

Me.Dirty=True
DoCmd.Close

The first one gives no errors but doesn't seem to dirty the form. The second on is giving me an error on Me.Dirty=True. Is there any way to dirty the form?

 

[philbullock1223]

I figured it out.

The first code was working, I just wasn't refreshing the form.

Phil

 

[Pat Hartman]

DoCmd.Save - saves the open object. You need to use

DoCmd.RunCommand acCmdSaveRecord

OR as some people prefer Me.Dirty = False