Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record Locks property (97)

    Record Locks property
    My form has its recordLocks property set to no.

    I would however like to lock any single record if certain criteria exists. Problem is that the has too many fields to make something like me.SomeControl.Locked = true a good choice. Is there some other, better way to get at the record & lock it all in one fell swoop then?

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record Locks property (97)

    If you are using a single form (not continuous) try setting the AllowEdits property of the Form to False.
    (I think this property exists in A97 but I can't check.)
    HTH
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Record Locks property (97)

    Don't confuse recordlocks with locking controls on a form. They're entirely different things. RecordLocks determines how the form handles locking in the underlying recordset when the data is being edited. Locking the controls prevents the data in them from being edited at all.
    Charlotte

Posting Permissions

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