Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2014
    Posts
    7

    Unanswered: Combobox ... Programmatically add or edit list by code

    Hi all;

    i need a code on Not in List that i can programmatically give the user the ability to choice between add new value to the list Or just edit it

    Your help is appreciated

    thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by f.dragon View Post

    ...i need a code on Not in List that i can programmatically give the user the ability to choice between add new value to the list Or just edit it...
    Sorry, but that makes no sense! Not in List will only execute if the item does not exist...if the item does exist (as it would have to be, in order to be edited) then the Not in List will not execute!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2014
    Posts
    7
    Quote Originally Posted by Missinglinq View Post
    Sorry, but that makes no sense! Not in List will only execute if the item does not exist...if the item does exist (as it would have to be, in order to be edited) then the Not in List will not execute!

    Linq ;0)>
    sure u right
    but i have repeated names .. i can't type it .. plus if i need to correct any name ... the combo see it as a new one
    so ... can i do what i need in After Update event for example ?
    thanks

  4. #4
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    You can add a new item to the combo box list with the following procedure:

    Updating Combobox when Not-in-list Event is active/

    You may use a separate Form for source table to edit the list, if needed.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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