Results 1 to 3 of 3
  1. #1
    Sibtain is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Karachi
    Posts
    15

    Angry Combobox Validation

    I have to verify the value of combo box on the basis If Value is not in List then user should prompt for confirmation and if user deny to change the value of combo box then it should comback to its origional state.

    I have coded the "On Change" In that through msgbox i have taken user openion in YES or NO, but when I select no (Means i dont want to change the value of this combo) its origional value is not being restored after applyiing (Me.ComboName.Undo) and new value or changed value is being reflecting.

    I dont know What to do now?

    Regards

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a link to Allen Browne's site. This particular link will demonstrate how to use "Not in List" for a combo box.

    http://allenbrowne.com/ser-27.html

    I hope this is what you are looking for.

    Alan

  3. #3
    Sibtain is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Karachi
    Posts
    15
    Dear Alan,
    I am very thankful for your reply, It gives me some idea about my some other work but perhaps i didnt explain my problem perfectly let me try one more time may be you can give me some solution.
    Actually I am Obtaining the values using query from the same field in which i am storing data, means the field which is being used to store data is also beiing used in a query to retrieve the items for the combo. The idea is, if user want to use any previously defined values then the user should be able to use those previous values and if the user wants to introduce new value for the field a prompt should be displayed to confirm it, if user then confirms then that new value should be store in the field and should also be reflected in the combo as an item. In this case the field could have any old value in it and if user deny to introduce new value then that old value should be reflected again like undo retrieve old values in any other record operation.
    I hope i tried to explain it very breifly plz guid me in this regards.

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

Similar Threads

  1. Replies: 29
    Last Post: 08-16-2011, 05:52 PM
  2. cascading combobox and validation rule violation
    By AndycompanyZ in forum Forms
    Replies: 7
    Last Post: 06-22-2011, 12:13 PM
  3. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  4. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  5. Validation on import
    By andy_42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2006, 03:52 PM

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
  •  
Other Forums: Microsoft Office Forums