Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: How to lock a field in a Tab?

    I am trying to lock a txt box in a tab for certain records. However When I use the code below on on current form. It either locks all the records or unlocks all the records in a tab control. I am able to accomplish this on a form alone but not in tab controls

    If Me.NewRecord Or Not Me!LockE Then
    Me.txtSecE.Locked = False
    Me.txtSecE.BackColor = 16777215
    else
    Me.txtSecE.Locked = True
    Me.txtSecE.BackColor = 11075496
    end if

    thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    My guess is you've selected Multiple Forms view. Change to Single Form, and I bet the problem goes away.

    Sam

  3. #3
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    I will take a look at that, I found a work around it. I created the checkbox outside the tab and dragged it onto the tab and on the tab control just hid the checkbox if it was on a different tab. It works
    ======================
    Levent
    Access 3

Posting Permissions

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