Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14

    Can I lock out fields in a form by keying off...


    I am trying to lock out 7 fieldsin a subform by keying off a value of a textbox, I want the 7 fields lock or non editable. how can i do this?

  2. #2
    rayc is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Dec 2005
    Location
    Montreal, Canada
    Posts
    19
    Set the Enabled and Locked properties of the textboxes.
    i.e.
    Me.MyTextbox.Enabled = False
    Me.MyTextbox.Locked = True

    However, be careful if other code sets the focus to these fields, if you do you'll get a runtime error.

  3. #3
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14
    Thanks I was just using locked= true.It works great thank you.

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

Similar Threads

  1. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  2. Feeding fields from one form to another
    By dahand in forum Forms
    Replies: 0
    Last Post: 02-15-2008, 01:48 PM
  3. Replies: 0
    Last Post: 03-26-2007, 12:24 AM
  4. File sharing lock count exceeded
    By bullwinkle55423 in forum Access
    Replies: 0
    Last Post: 03-22-2007, 11:58 AM
  5. Bounding Fields In a Form?
    By tempowls21 in forum Forms
    Replies: 0
    Last Post: 06-22-2006, 06:12 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 - Senior Forums