Hello,
I'm trying to use the following SQL to update a record in a table:
Where SQL, TblName, SValue and SKeyword are strong variables dimmed already.
I want to edit it so that it inserts a new record if it doesn't exist. Can it be done by modifying the SQL or do I have to use some if statement.
Best Regards,
Abdullah
I'm trying to use the following SQL to update a record in a table:
SQL:
SQL = "UPDATE " & TblName & " SET " & TblName & ".SValue = '" & SValue & "' WHERE (((" & TblName & ".SKeyword)= '" & SKeyword & "'));"
' Debug.Print SQL
CurrentDb.Execute SQL
Where SQL, TblName, SValue and SKeyword are strong variables dimmed already.
I want to edit it so that it inserts a new record if it doesn't exist. Can it be done by modifying the SQL or do I have to use some if statement.
Best Regards,
Abdullah