Label Visibility

[Jonny45wakey]

Hi not sure if this is achievable but here goes in the hope someone can help

I have a label "label1704" on a form "frmDayshift" which is hidden on the form load event.

On the form is a combobox "combo123" which is loaded with drop down values, when "NoProd" is selected i want the label to be visible, however; when scrolling back through the record navigator this label disappears.

Is there a way to keep the label visible on record navigation if the combobox value = "NoProd"?

Any ideas welcomed as always.

Regards

Jonny

 

[MajP]

If I understand correctly. When you move to another record from the current record you want it visible again.
If so use the forms on current event to set it back to visible. On current happens when moving to a different record.

 

[arnelgp]

as mentioned use Form's Current event:

Private Sub Form_Current()
Me.label1704.Visible = (Me.combo123 = "NoProd")
End Sub

also add code the combo123 AfterUpdate event:

Private Sub combo123_AfterUpdate()
Call Form_Current
End Sub

 

[Gasman]

Is there a way to keep the label visible on record navigation if the combobox value = "NoProd"?

Yes, test for it on each record. As @MajP states, that would be the current event.

 

[DHookom]

I would also consider using descriptive control names.