Marc
|
| Posted: 05/15/2004, 7:51 PM |
|
When a user update or save the data, I have to send a email to the admininstrator, that works fine...., the problem is that there is a condition about sending the email.
The email must to be send only if the value selected in the listbox ABOUT is "Question", if the user select any other value, the email isnt sent, the data must be saved, and the user is directed to another page.
I've tried CCDLookUp, like this:
if CCDLookUp(AboutField, SupportTable, "=Question", DBService) then
****the email code*****
else
end if
but it dont work, the email isnt sent....
sorry my english, im from Costa Rica...
IIS, WIN2000, ACCESS
|
|
|
 |
sewells
Posts: 13
|
| Posted: 06/13/2004, 9:22 PM |
|
the =question is incorrect, it neeeds to be <field name>=question.
|
 |
|
|
