Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Forms _ Docmd.sendobject Send Email On Continuous Form, But I Sometimes Have The Wrong Record Selected

Posted by: jmkeuning Mar 26 2020, 03:40 PM

I have a continuous form with contact info. Each record has an image of an envelope that can be clicked to send an email. The problem is that the image can be clicked when a different record is selected. This means that the email goes to the wrong person. How can I make it impossible to click the image without having the record active?

Posted by: GroverParkGeorge Mar 26 2020, 03:46 PM

I would move the clickable envelope image to the form's header instead of the detail section so that it appears only once and eliminates the ambiguity.

Posted by: jmkeuning Mar 27 2020, 12:13 PM

Using an actual command button solved the problem. So first I switched to a command button, but then I made the button transparent and laid it over my envelope image. It does the trick.