sending outlook using access vba

[VBKNIGHT]

I'm tryng to send a form using access vba.

i have an outlook form put value on fields that comes from my database then send the form.

the problem is when i received the email..the form fields/controls has no value.

here's my sample code.have just put some string on it not the actual records.

Sub Transfer_ToMail()
    Dim oApp As Outlook.Application
    Dim oMsg As Outlook.MailItem
    
    Dim oInspector As Outlook.Inspector
    Dim oPages As Outlook.Pages
    Dim oPage As Object
    Dim oControls As Object
    Dim oControl As Object
    
    Set oApp = New Outlook.Application
    Set oMsg = oApp.CreateItemFromTemplate("C:\Template\FORM_TEMP.oft")
    If Not oMsg Is Nothing Then
        Set oInspector = oMsg.GetInspector
        Set oPages = oInspector.ModifiedFormPages
        Set oPage = oPages("Email Notification")
        Set oControls = oPage.Controls
        
        Set oControl = oControls("FIELDNAME1")
        oControl.Value = "AAA-AA"
        
        Set oControl = oControls("FIELDNAME2")
        oControl.Value = "COMPANY"
        
        'oMsg.Display vbModal
        oMsg.To = "Gates, Bill
        oMsg.Send
        
    Else
        MsgBox "Couldnt find your template!"
    End If
    
    
    Set Inspector = Nothing
    Set Pages = Nothing
    Set Page = Nothing
    Set Controls = Nothing
    Set Control = Nothing
        
    Set oMsg = Nothing
    oApp.Quit
    Set oApp = Nothing
End Sub

[VBKNIGHT]

would it matter if i design the controls with readonly properties? but when i tested this function and display the form the controls has the value i have programmtically entered. but when i send it to my self it return empty values on controls.

why did i select readonly on properties? because i wanted it to be uneditable when the receiver clicked the forward mail function.

[VBKNIGHT]

ok the problem occur because i have checked the readonly properties of controls..when i unchecked readonly from these controls then run my code it works fine.

but then again i did not solved the real issue which is the form should not be editable when email forwarding.

[VBKNIGHT]

ok heres another question..if i make a script that would handle event when the receiver hit the forward button..is this script would be available to the recepient when i send the form? is the script attached/connected with the form i've sent?

[salvelinus]

If you're just sending a form, you could use DoCmd.SendObject acForm, "frmFoo", .... although you won't have as many options as when programming Outlook.

[VBKNIGHT]

my concern truly is with the outlook form that i've sent..i want it to be uneditable when the user i've sent the mail try to forward it.