Don't Save unless "OK"
I have a form that I would like for the only way for a record to be updated is when "OK" is clicked. The reason for this is because the "OK" button runs an insert statement that includes the username from their Novell account. My problem is if someone changes the record....then closes the form or previews the report the record gets updated, but the "lastupdatedby" field doesn't get updated because the insert statement didn't run. I guess what I'm asking is if there is a way to not have Access NOT to save a record upon closing or moving to print preview. Or any other suggestions are appreciated.
Thanks in advance,
Kacy
________
Kissing advice forums
I have a form that I would like for the only way for a record to be updated is when "OK" is clicked. The reason for this is because the "OK" button runs an insert statement that includes the username from their Novell account. My problem is if someone changes the record....then closes the form or previews the report the record gets updated, but the "lastupdatedby" field doesn't get updated because the insert statement didn't run. I guess what I'm asking is if there is a way to not have Access NOT to save a record upon closing or moving to print preview. Or any other suggestions are appreciated.
Thanks in advance,
Kacy
________
Kissing advice forums
Last edited: