Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,
    Im trying to help someone who used a Microsoft Access template for reporting Radiology Issues - and now needs to make changes to the template. Ive fixed everything she needs except clicking a button on a form to bring up the Outlook mail message addressed to the person selected on a SUBFORM.

    The change is: originally, there is a macro written to on click bring up the Outlook mail message addressed to a name in a field on the MAIN form. That original field needed to be many, so it is now a field on a subform. Ive been searching for this particular problem but so far, Ive had no luck. I do not need any other pieces of the email filled in just the email address of the person selected on the subform. I tried replacing the old field name with different versions of the [form].[formname].[fieldname].

    Ive attached a slimmed down version of the OLD database that works with the Main Form and macro. I also attached the NEW version I was trying to get to work with the subform.
    I would appreciate any help very much.

    Thanks,
    Vicky
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try the following.

    1) Open the subform frmIssueContactDetailSub in design view.
    Select the IssueContact combo box.
    Set its Row Source property to Contacts instead of an SQL statement.
    Set its Column Count to property to 4.
    Set its Column Widths property to 0;0.65";0,65";0
    Close and save frmIssueContactDetailSub.

    2) Open the macro Issues Form Macros in design view.
    Click in cmdEmailAssignedTo : On Click.
    Set the To argument of the SendObject command to

    =[frmIssueContactDetailSub]![IssueContact].[Column](3)

    (columns start counting at 0 so Coluymn(3) is the 4th column, the one containing the e-mail address)
    Close and save the macro.

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you as usual Hans!
    I will do this...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •