Linda
|
| Posted: 07/31/2002, 12:12 PM |
|
Hello All,
I'm using CC, MSAccess and ASP.
I am making a mailbox. If I show the message in a recordform, there are (besides the insert button) three buttons - Update, Delete and Cancel.
The Update button I'm using to answer the mail, the Delete button for delete the record and Cancel for going back to the mailgrid. So far no problem.
But I like to give the mailrecord a mark that the message was read (msgread = 1)if the user choose the Cancel button. I've tried the event before cancel: fldmsgread=1, but the record isn't saved, so that won't work.
Who has a solution for this (small) problem?
Thanks in advance
Linda
|
|
|
 |
Nicole
|
| Posted: 08/02/2002, 5:40 AM |
|
Linda,
no operation with the table is made when Cancel is hit. User just redirected to the initial page.
So to update the record you should execute custom query in Before Cancel event. Here is sample asp code:
cn.execute "update table_Name set msgread=1 where primary_key_name= " & ToSQL(GetParam("PK_primary_key_name"), "Number")
|
|
|
|
|
