Form with a Text Box Email

[SP76]

Hi,

I have a form with a text box and what I want to be able to do is when someone clicks on it I want it to open up into Microsoft outlook, is this possible?

Then they can select someones name from the address book and the form is emailed to them.

 

[SP76]

Anyone help?

 

[pl456]

You may want to try something like

Application.DoCmd.SendObject

If you look at the help files in access it will tell you how to specify output formats etc.

To get it to happen when you select a text box you would need to put the code under the Gotfocus event of the text box.