I have a Access 2007 database that I wish to be able to click a button and update Null values in a table column with the current date when the button is clicked. For some reason it just won't update.
I created a query qrySubmitUpdate that has the following SQL.
UPDATE tblSubmissions SET tblSubmissions.[fldDateSent] = Date()
WHERE (((tblSubmissions.[fldDateSent]) Is Null));
If I switch the query to view mode, it will show me the appropriate number of rows that need to be updated - all rows are blank and the calendar icon appears next to each row you click on.
The fldDateSent field is set to Date/Time for Data Type. No default value or validation rule/text. Input mask is empty and the format is set to Short Date (Doesn't matter if the date is set to short date or empty).
Any idea what I am missing? Thank you.