Enable button based on two values

[janith]

Hi,

I want to enable a button on the form based on either 2 values

If txname.value = " vb- 99453037" or "43331954" then
Button. Enabled = true
Else
Button. Enabled = false

It only works for first value (vb-99453037)and not for both any suggestions??

 

[pbaldy]

You have to repeat the field:

If txname.value = " vb- 99453037" or txname.value = "43331954" then

 

[janith]

So by doing so can I also include a third value?

 

[pbaldy]

Sure. If it's something that will change over time, it might make more sense to have a field in a table whose value will determine this. You don't want to have to change the VBA code every time they add a code or whatever.

 

[janith]

True that make sense.. Probably will try a combo box to achieve the same result.. Thanks

 

[pbaldy]

Happy to help!