I have a form on which there is a tabcontrol and on this onr of the tabpages
is a tick box which opens Outlook with data
from the main form and prompts the user to amend the message before being
sent.
The code is
Private Sub Loadtxt_Click()
Dim oA As Outlook.Applica tion
Dim oM As Outlook.MailIte m
Set oA = CreateObject("O utlook.Applicat ion")
Set oM = oA.CreateItem(o lMailItem)
If Me!Loadtxt = True Then
oM.Subject = "Upload to Online " & Me.Docnumtxt
oM.Body = "Please upload this document to Online " & vbCrLf & "Document
Number: " & Me.Docnumtxt & vbCrLf & "Author: " & " " & Me.DocAuthortxt &
vbCrLf & "Document URL: " & " " & Me.DocURLtxt
'then you can send it
'oM.Send
' or display it for editing
oM.Display
End If
End Sub
On the tab control is a subform called
tblDocSubjectss ubform which has a control called cmbPsubject. I want to
include in the email the value of this control and have used this code
& me.tblDocSubjec tssubform(cmbPS ubject) but it doesn't work. How can I
reference the control on the subform?
TIA
Tony Williams