Thread: Record Allowedits Label
05-26-16, 19:57 #1Registered User
- Join Date
- Oct 2007
Unanswered: Record Allowedits Label
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!
05-27-16, 10:01 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
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 foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007