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

    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
    Richmond, Virginia USA
    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

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

    Linq ;0)>
    Hope this helps!

    The problem with making anything 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