test combobox selection for certain value (1 Viewer)

P

pse07

New member

Local time

Yesterday, 19:40

Joined

Dec 12, 2017

Messages

2

• Dec 12, 2017

• #1

I know this has to be easy....
I am trying to test the value of a combo box selection on a form to determine if I make another text box visible on the same form.

If [CombCategory] = "Autos" Then
License_Number.Visible = True
Else
License_Number.Visible = False
End If
this code is an after Update event
it always comes back false and removes the License_Number text box
:banghead:

 

P

pse07

New member

Local time

Yesterday, 19:40

Joined

Dec 12, 2017

Messages

2

• Dec 12, 2017

• #2

Never mind...I deleted the combo box and put one back in and used the same code and it worked fine.......

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 19:40

Joined

Aug 30, 2003

Messages

36,124

• Dec 12, 2017

• #3

Thanks for the update, and welcome to the site!

 

missinglinq

AWF VIP

Local time

Yesterday, 22:40

Joined

Jun 20, 2003

Messages

6,423

• Dec 12, 2017

• #4

Although we usually think of Forms, or entire Databases, when we speak of corruption, individual Controls, such as Comboboxes, can and do become corrupted...and that's apparently what happened here. The test and the fix are one and the same...deleting the Control then re-creating it, just as you did!

Linq ;0)>