Using MS Access: Multiple updates in one Access SQL statement, access sql, constraint

Using MS Access: Multiple updates in one Access SQL statement, access sql, constraint


Sub RunMultiSQL()

DoCmd.SetWarnings False

DoCmd.RunSQL("UPDATE tblYourTable SET Field1='Yes' WHERE Field2 = 'A'")
DoCmd.RunSQL("UPDATE tblYourTable SET Field1='No' WHERE Field3 = 'B'")

DoCmd.SetWarnings True

End Sub


www.svdeals.com