Results 1 to 4 of 4
  1. #1
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479

    Delete name typed in combo box

    I have a combo box that contains Name_ID, FirstName, LastName and Company.
    Some times there is a need to add a new name to the list.

    I have a form to do this.
    However when I click on the command button to open the form to add a new name I get an error that says The text you entered isn't in the list.
    To keep the error from occurring I delete the name I typed in combo box.

    The question:
    How can I delete the typed in name with code so the user does not have to delete it manually.

    Thanks,
    DAle

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried using the "Not In List" event of the ComboBox?

  3. #3
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Just found it.
    Thanks RuralGuy

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Great! Glad we could help.

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

Similar Threads

  1. Replies: 11
    Last Post: 06-05-2013, 08:15 AM
  2. Replies: 1
    Last Post: 05-24-2012, 12:34 PM
  3. This expression is typed incorrectly
    By Ray67 in forum Queries
    Replies: 9
    Last Post: 01-03-2012, 12:53 PM
  4. Replies: 6
    Last Post: 08-08-2011, 10:29 AM
  5. Get value typed in for a Parameter query
    By terryvanduzee in forum Forms
    Replies: 1
    Last Post: 10-14-2009, 03:01 AM

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