Getting Data from Current Form

[BayEnder111]

Hi Guys,

Apologies if this is a ridiculously easy question but I'm very rusty on the old VBA at the moment!

I have a form in Access which I've added an email button to try and email the contents of the current record. I'm fine with calling an email template and formatting the HTML body however struggling with calling the contents of the current record in the form.

In VBA how do I call the current record displayed in the form and output the fields please?the form is called frmMI and I have Application, Priority fields etc.

Thanks.

 

[healey21]

Take a look at this thread from Access Programmers forum to see if it helps.

https://access-programmers.co.uk/forums/showthread.php?t=196596

It shows using the Me. Object name to be placed into the EMail like:

.To = Me.EmailAddress

 

[BizBoy]

Take a look at this thread from Access Programmers forum to see if it helps.

Thanks for suggestion. I guess, this will help me also. Have a nice day ahead.

Hope, such kind of replies are allowed.