I need to update two fields in a table. I can successfully update the table if I update each field one at a time using the code:
strSQL = "UPDATE tbl_rem set tbl_rem.(RemDate1] = #' & dtDate1 & "# where tbl_rem.[id] = (" & NumID & ");"
strSQL = "UPDATE tbl_rem set tbl_rem.(RemDate2] = #' & dtDate2 & "# where tbl_rem.[id] = (" & NumID & ");"
There has to be a way to update multiple values, but I can't get anything to work nor can I find on-line help.
Your help would be GREATLY appreciated!