MontgomeryPete
Instructor
Hello:
I am trying to update a field based on the action taken on a checkbox as follows:
The error message returned is Object required (Error 424)and the Set strSQL is highlighted.
I can't seem to get around the debug statement.
Any thoughts?
Pete
I am trying to update a field based on the action taken on a checkbox as follows:
Code:
Private Sub Dispatched_AfterUpdate()
Dim strSQL As String
Set strSQL = "UPDATE Ride SET TimeDispatched = Now()"
DoCmd.RunSQL strSQL
End Sub
The error message returned is Object required (Error 424)and the Set strSQL is highlighted.
I can't seem to get around the debug statement.
Any thoughts?
Pete