Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Record Allowedits Label

    Hi All,

    I have a label on my access form that appears when a record is locked and the user cannot edit it. Once the user clicks "EDIT" the label disappears. However, it seems after the record auto saves or something happens that makes it locked again, the label does not appear but the user can't make chances. How can I make this happen so that the label appears anytime the record is not allowing edits? Thank you!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If you have a button to save your Record, then after the code to save it use

    Me.LabelName.Visible = True

    Then, in case the user simply moves to another Record to save the Current Record, ans assuming that no Me.LabelName.Visible = True
    is editable when you first move to it

    Code:
    Private Sub Form_Current()
     Me.LabelName.Visible = True
    End Sub


    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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