Jamie,
Is it possible to send a record in a form as an email? < Yes, definitely
When you click a button? < Yes.
If so any ideas/ solutions? <
The first technique you might want to consider is using the SendObject
method in Access. SendObject will send the data associated with a Form,
Query or Report (as well as other objects). If you want to send *only* one
record, you would need to create a Query or Report that returns only the
record to be emailed; in the Form you would need to be sure that the
RecordSource of the form contains only the record you wish to send.
Another technique to consider is to use Outlook Automation (presuming that
you use Outlook as your email client). Here are a couple of links to
articles on the subject (the first link has very easy to follow code
samples):
MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj
Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088
HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948
ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881
Also, have a look at Tony Toews' email page:
http://www.granite.ab.ca/access/email.htm