Using IIf to activate input

  • Thread starter Thread starter Sheila
  • Start date Start date
S

Sheila

I would like to be able to manipulate whether a group of
input controls are Enabled or not based on a previous
answer/input early in the form.

For example, If "Materials Developed" = yes, then
activate "Materials Description" memo input.

How do I do this?
 
I would like to be able to manipulate whether a group of
input controls are Enabled or not based on a previous
answer/input early in the form.

For example, If "Materials Developed" = yes, then
activate "Materials Description" memo input.

How do I do this?
Click to expand...
The most simple way is to set the enabled property to whatever your
Yes/No control says. Use it's AfterUpdate event something like...

Private Sub chkMtrlsDev_AfterUpdate()
Me.txtMtrlsDscrpt.Enabled = Me.chkMtrlsDev
End Sub

This would toggle txtMtrlsDscrpt enabled/disabled with checking of the
chkMtrlsDev checkbox.

- Jim
 
Back
Top