Disable filed condition

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
 
T

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
Click to expand...
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking Text Box - based upon Combo Box Selection 4
Disable Print Drawing Created in Word 1
consolidation data in one row 2
VSTO C# add in Outlook.Appointment error 0
Loop thru xx No. of sheets until the four strValue combo's are found 6
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Project 2010 "Project has stopped working" error when attempting to import from Excel 0
field level control 6

Top