I must be missing something here:
strSQL = _
"UPDATE ItemQuery SET ItemQuery.ItemDateCreated = Date()"
"WHERE ItemNumber=" & ItemNumber7
CurrentDb.Execute strSQL, dbFailOnError
The ItemNumber7 is a field name on the current form
The Where Clause is highlighted in Red in the code window. I guess I have a comma missing somewhere