Experts, I have a form with a subform linked by LetterOfCreditID;ProjectID.
I have a lblExpired that I want to appear for when me.expiredYN = Yes but the lbl is only suppose to turn on for that particular record and not the others. For example, there are 5 records on the subform and 2 of them are [ExpiredYN] = Yes then turn on the lblExpired for only those two records.
With the code I have now, the lblExpired stays on for all the records when [expiredYN] = Yes
How can I make the lblExpired turn on for when [ExpiredYN] = Yes but for only those records? (ExpiredYN is a true YN field. with name cboExpired) lblExpired has its visible property = False
Private Sub Form_Current()
If Me.ExpiredYN = 1 Then
Me.lblExpired.Visible = True