Results 1 to 4 of 4
  1. #1
    ShostyFan is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    76

    comboBox restrictions

    I have a combo Box with , Sale, Repair, Approval, and Void as selection options.


    When a user selects Repair or Approval I need to be able to change the data at a later point to Sale, but once Sale is selected they can not change the value to anything other then Void.
    I am guessing and checking on which event to use so it is pretty frustrating.

    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    In the before update event you can compare the Value and OldValue properties, and cancel the update if appropriate.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ShostyFan is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    76
    thank you. this worked fine.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 07-08-2014, 01:47 PM
  2. User Restrictions based on Field Content in MS Access
    By gori1084 in forum Database Design
    Replies: 7
    Last Post: 05-29-2014, 12:18 PM
  3. restrictions for different users
    By joe1987 in forum Access
    Replies: 7
    Last Post: 12-11-2011, 05:05 PM
  4. help with creating data restrictions
    By aburaed in forum Access
    Replies: 3
    Last Post: 08-30-2011, 05:41 PM
  5. Form Restrictions
    By Evgeny in forum Forms
    Replies: 4
    Last Post: 04-22-2010, 03:50 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