View Single Post
Old 04-24-2012, 03:08 AM   #3
';drop database master;--
VilaRestal's Avatar
Join Date: Jun 2011
Location: UK
Posts: 1,046
Thanks: 20
Thanked 220 Times in 205 Posts
VilaRestal is on a distinguished road
Re: Help please! Save Cmd Button not wkng

And there's a lot of code there for something that should be quite simple. I guess you've been adding lines trying to get it to work.

Does this work:

Private Sub Save_and_Close_Form_Click()
    RunCommand acCmdSaveRecord
    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO [ClosedTktT] SELECT * FROM [ChronicTkt# T] WHERE [Chronic Tkt Number] = " & Me![Chronic Tkt Number]
    RunCommand acCmdDeleteRecord
    DoCmd.SetWarnings True
End Sub

VilaRestal is offline   Reply With Quote