The code I'm using does work fine at the moment, but I am trying to reduce the amount of data on the form (maybe I don't need to any opinions appreciated.)
This piece of code takes the details off the open form and puts them into outlook. Great!Code:oMail.Body = Me!Site_Name & " " & Me!Asset_Type & vbCrLf & Me!Address_1 & vbCrLf & Me!Address_2 & vbCrLf & Me!Address_3 & vbCrLf & Me!Postcode & vbCrLf & vbCrLf & "Hospital Details:" & vbCrLf & Me!Hospital_Name & vbCrLf & Me!Hospital_Address & vbCrLf & Me!Hospital_Postcode & vbCrLf & "Tel: " & Me!Hospital_Telephone oMail.Subject = Me!Site_Name & " Details"
But the way I've done this means I have to display a lot of information that's really no use on the form. When there are 7000 records on that form I'm concerned it may slow it down if I have all the fields for every record.
I wans hoping I can reference a query rather than the "me!". Is this possible? I'm assuming it is I just cant find what I'm looking for.
(this is part of me clearing up 2 years of bad practice. haha)
Thanks.