Results 1 to 2 of 2

Thread: Control locking in Access 2000

  1. Apr 15th, 2002, 03:20 PM #1
    Larry Smith
    Larry Smith is offline

    Thread Starter
    New Member
    Join Date
    Mar 2002
    Posts
    8

    Question Control locking in Access 2000

    How do I set the properties of control to be locked based off of the values in another control. I have a picklist that has values that go through a review and if a certain value is entered into a text box, I want to lock that particular item in the picklist and have it give a message to the user.
    Reply With Quote Reply With Quote
  2. Apr 16th, 2002, 05:29 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    On the after_update or lost_focus events, put me.<control name>.locked=true

    Where <control name> is your name of the control.

    Note : If you lock it - you may need to unlock it for a different selection...


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width