Can anyone please help me with this vba code? I'm trying to set a label caption on a subform, depending on the "IndxType" value on the main form. This code is on the subform's OnLoad event:
Dim indextype As String
indextype = Forms!FrmSearchIndexMain.IndxType
If (indextype = "Mkt") Then
Me.Label34.Caption = "Week Change"
Else
Me.Label34.Caption = "Period Change"
End If
Regardless of what the "IndxType" value is, this label caption keeps showing "Week Change".
Thanks for any help!
Dim indextype As String
indextype = Forms!FrmSearchIndexMain.IndxType
If (indextype = "Mkt") Then
Me.Label34.Caption = "Week Change"
Else
Me.Label34.Caption = "Period Change"
End If
Regardless of what the "IndxType" value is, this label caption keeps showing "Week Change".
Thanks for any help!