Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    14

    Unanswered: Populating Subject Line with Form Data

    I managed to create an button command in Access 2010 which allow users to send an email directly from the form they are filling out. The email being sent from the form serves to notify certain individuals that an entry has been made. On the form itself, the unique ID number assigned to each new entry is visible. Because this is the best way to locate a specific entry in a database of hundreds, we ask that the user include the entries unique ID number in the subject line. At the current time, the users are manually entering in the unique ID number into the subject line. Is there a way we can automate this so that the ID number of the specific form is placed in the subject line?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    In the coding for the button...

    Dim UID as variant
    UID = me!MyUniqueIDField

    Then in subject parameter of the way you're sending the email (I'm assuming sendobject), you'd put in something like (again, for the subject paramter part), "UniqueID = " & UID
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Tags for this Thread

Posting Permissions

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