Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Form Control Syntax Question (A2K SP1)

    Is there a way to lock all controls on a form with a single command, e.g. Forms![Form Name]![??].Locked = True

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form Control Syntax Question (A2K SP1)

    >>Is there a way to lock all controls on a form with a single command, e.g. Forms![Form Name]![??].Locked = True <<

    The closest you could get is: Me.AllowEdits=False

    This will lock the controls from changing an existing record, but will allow you to add a new record (I don't know precisely what you goal is). To stop that, set the .AllowsAdditions property = False.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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