I have a form that has a continuous subform showing historical data. There's a field in this continuous subform called Notes. When someone clicks there, I want to tell them that they cannot edit these. It's working right now, but my setup is that the message appears in the Form Header in a label box. Here's the code I'm using:
Private Sub NOTE_Click()
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Visible = True
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Caption = "Historical Credits cannot be edited. Contact the Analyst if you notice an error."
PauseFor 5
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Visible = False
End Sub
Public Sub PauseFor(ByVal Period As Double)
Dim Start As Double
Start = Timer
While (Timer - Start) < Period
DoEvents
Wend
End Sub
I'd perfer to have the label on top of the subform itself to better get the user's attention. Is this possible? I've tried bringing the label to front and the subform to back. I've also tried anchoring the label, but it's always hidden behind the subform. Is there a solution or is this a limitation?
Private Sub NOTE_Click()
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Visible = True
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Caption = "Historical Credits cannot be edited. Contact the Analyst if you notice an error."
PauseFor 5
Forms!ENTRY_MONTHLY_CRED_HIST.InfoLabel.Visible = False
End Sub
Public Sub PauseFor(ByVal Period As Double)
Dim Start As Double
Start = Timer
While (Timer - Start) < Period
DoEvents
Wend
End Sub
I'd perfer to have the label on top of the subform itself to better get the user's attention. Is this possible? I've tried bringing the label to front and the subform to back. I've also tried anchoring the label, but it's always hidden behind the subform. Is there a solution or is this a limitation?