IIf statement Question 2

[BubbaJean]

The statement below works great, now the user want to add in additional requirements when selecting items
for example if the user select
CAPACITORS, [Composition] is enabled, if Composition ="Aluminum",
Turn off [TempCoef]
if other than "Aluminum"
Turn off [RippleCurrent] and [CurrentLeakage]

how do I update the code below to include these new rqmts??


If txtInvisible = "CAPACITORS" Then

Me!Composition.Enabled = True
Me!RippleCurrent.Enabled = True
Me!CurrentLeakage.Enabled = True
Me!TempCoef.Enabled = True
Else
Me!Composition.Enabled = False
Me!RippleCurrent.Enabled = False
Me!CurrentLeakage.Enabled = False
Me!TempCoef.Enabled = False
End If

 

[PaulBricker]

If txtInvisible = "CAPACITORS" Then

Me!Composition.Enabled = True
Me!RippleCurrent.Enabled = True
Me!CurrentLeakage.Enabled = True
If Composition = "Aluminum" Then
Me!TempCoef.Enabled = False
Else
Me!RippleCurrent.Enabled = False
Me!CurrentLeakage.Enabled = False
End If
Else
Me!Composition.Enabled = False
Me!TempCoef.Enabled = False

Try this

Paul


You don't say if you want to do anything
End If

 

[BubbaJean]

How do I get the fields to turn back on if Aluminum is or isn't selected??

 

[BubbaJean]

I got this to work (see code below) Thanks for the help


If txtInvisible = "CAPACITORS" Then
Me!RippleCurrent.Enabled = True
Me!CurrentLeakage.Enabled = True
Me!TempCoef.Enabled = True
If Composition = "Aluminum" Then
Me!TempCoef.Enabled = False
Me!CurrentLeakage.Enabled = True
Me!RippleCurrent.Enabled = True
Else
Me!TempCoef.Enabled = True
Me!CurrentLeakage.Enabled = False
Me!RippleCurrent.Enabled = False
End If
Else
Me!RippleCurrent.Enabled = False
Me!CurrentLeakage.Enabled = False
Me!TempCoef.Enabled = False
End If

 

[hneal98]

Just make a small change to the following portion of the if statements:

If Composition = "Aluminum" Then
Me!TempCoef.Enabled = False
Else
Me!RippleCurrent.Enabled = False
Me!CurrentLeakage.Enabled = False
Me!TempCoef.Enabled = True
End If

I added one line to the Else portion.

 

[PaulBricker]

Thanks hneal98. Missed that line.

Paul

 

[hneal98]

No problem.

 

[hneal98]

Thanks for the star, but I really did not do anything.