Docmd.close,,acSavePrompt

[shyamsundar]

Hi Tech Guys

DoCmd.Close , , acSavePrompt is not prompting onclick even, am i doing anything wrong.

Pl. Help Shyam
cwizshyam@yahoo.com

 

[JeremyNYC]

Shyam,

Sometimes people get confused with this command. The save you would be prompted for is a change in the design, not a change in the record. If you're looking to save the record, you can use:
call docmd.RunCommand(acCmdSaveRecord)

There's no built in prompt, so you'd want to wrap it in an if structure, maybe like this:

If vbYes = MsgBox("Do you want to save the record?", _
vbQuestion + vbYesNo, "Save Record?&quot Then
Call DoCmd.RunCommand(acCmdSaveRecord)
End If

Hope this helps.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[mp9]

Or you might only want to ask the question if the record has been changed (is "dirty&quot, so if you have a command button you're clicking to close the form you might want something like:

If Me.Dirty Then
    If MsgBox("Do you want to save changes to this record?", vbYesNo + vbQuestion, "Save") = vbYes Then
        Call DoCmd.RunCommand(acCmdSaveRecord)
    End If
End If

http://www22.brinkster.com/accessory/

 

[shyamsundar]

Jeremy & mp9,

Great, it works thanx very much for the time.


Shyam Shyam
cwizshyam@yahoo.com