Syntax error (missing operator) in query expression

[rikklaney1]

So I'm getting an error telling me

Run time error '3075'
Syntax error (missing operator) in query expression '8/24/2015 2:10:39 PM'

When I have this as an on click event for a button.

DoCmd.RunSQL "UPDATE [tblexelpick] SET [close time] = " & Now() & " WHERE [tblexelpick].[ID] = " & Me.List26.Column(0, 0)



When I click the button I need it to put the current time in the [close time] field of the first record in list26. Any ideas what I'm doing wrong?

 

[pbaldy]

Try

DoCmd.RunSQL "UPDATE [tblexelpick] SET [close time] = #" & Now() & "# WHERE [tblexelpick].[ID] = " & Me.List26.Column(0, 0)

 

[rikklaney1]

That did it. Thanks for the help. Much appreciated

 

[pbaldy]

Happy to help!