Help...Am I heading in the right direction???
What event are you calling the LabelHide() sub from?
You need to find the Position_Change event and call it from there so it gets
executed every time the value in the Postion box or field changes.
Private Sub Position_Change()
LabelHide
End Sub
Albert
Quote:
>I entered the sub as you stated...but the caption Management Position! is
>still showing even when the Assistant Manager position reads something else
>i.e. Salesclerk...etc...
>I entered into the Caption label but that makes it constant.
>Any more ideas?
>: )
>> > I think I'd set the Caption and Color properties in the property box of
>> the
>> > label and then just code this. You don't really need to know or set the
>> > [Position] value in the Else statement because whatever is in the
>> [Position]
>> > field won't be visible if the code makes it to the Else clause.
>> > Public Sub LabelHide()
>> > If [Position] = "Assistant Manager" Then
>> > Label18.Visible = True
>> > Else
>> > Label18.Visible = False
>> > End If
>> > End Sub
>> > >Hello,
>> > >I am trying to write a code that will show a lable next to a position
>> (job)
>> > >if that position shows it is Assistant Manager. Below is what I have
>> written
>> > >so far...how far off track am I?
>> > >Thanks...
>> > >Public Sub LabelHide()
>> > > If [Position] = "Assistant Manager" Then
>> > > Label18.Visible = True
>> > > [Label18Name] = "Management Position!"
>> > > [Label18Name] = RGB(255, 0, 0)
>> > > Else
>> > > [Position] = "" <--(Do not know what to put here)
>> > > Label18.Visible = False
>> > > End If
>> > >End Sub