Disable filed condition

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

Hi, I want to disable the field depens on other field input as below:

data 1 data2
A Enable the field for input
B Enable the field for input
C Disable the file for input

I try below only work for condition either one in data1
Me.data2.Enabled = (Me.status = "A")

Below is error
Me.data2.Enabled = (Me.status = "A" or "B")

Regards
Tom
 
Sorry, fixed it ... Thanks you very much!

tom said:
Dear KC-mass,

When I apply below

Me.Data2.Enabled = IIF(Data1 ="A" OR Data1 = "B",True,False )

error as (2164) and above highlight in Yellow colors

Regards
Tom
 
Dear KC-mass,

When I apply below

Me.Data2.Enabled = IIF(Data1 ="A" OR Data1 = "B",True,False )

error as (2164) and above highlight in Yellow colors

Regards
Tom
 
Back
Top