Disable field based on entry in another field

[50gumbys]

I have a field that uses a drop-list. When I select one of the options from the list, I'd like to make another field (it's a Yes/No field) on the form disabled, to ensure the user doesn't try to use it.

I thought I could create an expression, using the IIF statement (thinking it was just like Excel); but haven't found how to deactivate the other field.

Does anyone have any suggestions?
Thank you - much appreciate your help.
Love this website!

[MMcCarthy]

I have a field that uses a drop-list. When I select one of the options from the list, I'd like to make another field (it's a Yes/No field) on the form disabled, to ensure the user doesn't try to use it.

I thought I could create an expression, using the IIF statement (thinking it was just like Excel); but haven't found how to deactivate the other field.

Does anyone have any suggestions?
Thank you - much appreciate your help.
Love this website!

You will need to create an After Update event on the combo box (drop down list) to disable or lock the other control. BTW, I am assuming you are talking about a form here as none of this can be done on the table.

You will need something like this.

Private Sub comboName_AfterUpdate()

   If Not IsNull(Me.comboName) Then
	  Me.CheckboxName.Locked = False ' User can't change the value
   Else
	  Me.CheckboxName.Locked = True
   End If

End Sub

Mary

[50gumbys]

Hi Mary,

Thank you SO much for your lovely solution!
It works great !!!

I've included a few other fields as well that need to be deactivated.
(one day I'll get into VBA)

Thanks again Mary - much appreciate your assistance.
Lori

[MMcCarthy]

Hi Mary,

Thank you SO much for your lovely solution!
It works great !!!

I've included a few other fields as well that need to be deactivated.
(one day I'll get into VBA)

Thanks again Mary - much appreciate your assistance.
Lori

You're welcome Lori and Merry Christmas

Mary