Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting a caption on a subform

Status
Not open for further replies.
as0125

as0125

Technical User
Jun 3, 2004
70
0
0
US
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!
 
Sort by date Sort by votes

sorry -- just realized i posted in the wrong section of the site.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
301
serino
serino
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
174
combo
combo
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
173
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
334
combo
combo
dan
  • Locked
  • Question
Add a variable to Subject in formemail.pl
Replies
4
Views
80
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top