What is the best way to layout your form if you wish to update a record (MS Access)? I already have a 'Add Record' form with several fields
- is it best just to use that same form and then, in the script, use
This would mean completing all fields when only one field may need updating, such as an email address.Code:
sSQL="Update tableName SET fieldName WHERE .....
I am proposing to use something like this:
sSQL="UPDATE tblWolf " &_
"(fullName, wolfID, telNo, address, email, description, received, [action], dispatched)" &_
" SET ('" & my_fullName & "', " & my_wolfID & ", " & my_telNo & ", '" & address & "', '" & my_email & "', '" & my_description & "', #" & my_received & "#, '" & my_action & "', '" & my_dispatched & "')"
' write on screen
Response.write "<div align='center'><p class='font'>The record has been updated.</p></div>"