Results 1 to 2 of 2
  1. #1
    laboymc is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2015
    Posts
    1

    ComboBox Value List Select No and prompt to send email.

    Hi,

    I have Access 2010 and I created a form with a combobox value list of Yes and No and if selection is No then send email. The code I am using is as follow:
    Private Sub Combo261_Change()


    If Me.Combo261.Value = No Then


    I tried the DoCmd.SendObject

    and it gives me an error.

    Please Help!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    What is the error message?

    The combobox is UNBOUND?

    If Me.Combo261 = "No" Then
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 01-07-2015, 02:10 PM
  2. Replies: 5
    Last Post: 05-07-2014, 09:25 AM
  3. How to select ComboBox list in Run time
    By sdondeti in forum Forms
    Replies: 2
    Last Post: 06-20-2011, 10:21 AM
  4. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  5. send email to email addresses in database?
    By cnstarz in forum Access
    Replies: 5
    Last Post: 03-02-2011, 09:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums