N Neo Registered User. Local time Today, 18:24 Joined Mar 5, 2003 Messages 42 Mar 6, 2003 #1 I want to do this but not sure how to code it If me.chkUser = True Then MsgBox " Do you want to update If yes then Run SQL If no Dont run SQL thanks in advance for the help
I want to do this but not sure how to code it If me.chkUser = True Then MsgBox " Do you want to update If yes then Run SQL If no Dont run SQL thanks in advance for the help
J Jon K Registered User. Local time Today, 18:24 Joined May 22, 2002 Messages 2,209 Mar 6, 2003 #2 If Me.chkUser = True Then If MsgBox("Do you want to update?", vbYesNo) = vbYes Then DoCmd.SetWarnings False DoCmd.OpenQuery "NameOfUpdateQuery" DoCmd.SetWarnings True End If End If
If Me.chkUser = True Then If MsgBox("Do you want to update?", vbYesNo) = vbYes Then DoCmd.SetWarnings False DoCmd.OpenQuery "NameOfUpdateQuery" DoCmd.SetWarnings True End If End If
