In my table I have a field that is a Yes/No value.
Im my form, I have the option to check the box if the condition applies.
If the client is RECOMMENDED, I check the box (this gives a value of -1 and if not checked gives a value of 0).
The problem is that when I create a button in that form to send an automated email and that I program the field RECOMMENDED in vba coding,
The value that gets written in the email is a -1.
How can I changed this to display RECOMMENDED instead of the -1 value.
What is the vba code required to display a different value then the one showed in that field (-1 or 0 in that case)
Thanks
Pjay