[MS_AccessPros] Object visibility

 

I am trying to get a field to appear and disappear when a certain value is entered in a textbox. I have been able get the text box to appear when the correct value is selected and disappear when the value is changed to another value, but if I choose to make the textbox blank the other textbox does not disappear. Also when the textbox is visible it remains visible when scrolling through all the other records even when the value in the textbox changes to a value that should make it go blank. below is the code I am using.

Any help would be appreciated.

Thanks Paul


Private Sub cboServiceProvider_AfterUpdate()

If cboServiceProvider = "Advant-Edge Solutions" Then

lblChemoWaste.Visible = True

txtChemoWaste.Visible = True

ElseIf cboServiceProvider <> "Advant-Edge Solutions" Or cboServiceProvider.Value = " " Then

lblChemoWaste.Visible = False

txtChemoWaste.Visible = False

End If

End Sub

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___