I'm trying to create a button in Access that will update a record in an Oracle database based on info that's filled into textboxes by the user. I've created "add", "delete", and "clear" buttons but I've never created an "update" button before. So, I really don't know how to code it. Here's what I've got so far. This is obviously not correct. Anyone know what I'm doing wrong?
Private Sub btnUpdate_Click()
Dim strSQL As String