Enable

[masalachol]

Hello:

What would be your suggestions on the following:

fielda filedb fieldc checkbox
111111 222222 333333

How would you go about writing a simple event that would do the following on the above fields that are on a form.

If fieldc = 3333333
then
disable the checkbox
else
enable the checkbox
fi

 

[mndrlion]

In the Form's On Current event do something like this

if fieldc = 333333 then
checkbox.enabled = true
else
checkbox.enabled = false
endif

 

[masalachol]

Thanks for your reply and sorry that I have taken long on the response.

Private Sub Tracked_Enter()

If Branch = 3000004 Then
Tracked.Enabled = True
Else
Tracked.Enabled = False
End If

End Sub

I am trying your suggestion by right clikcing on the check box field "Tracked" thus going to properties ==> then on "enter" select [event procedure]and click on the .... button. The Private Sub Tracked_Enter() appears and place the suggested if condition statements. Looking forward to hearing what I am doing wrong

 

[mndrlion]

If the Branch field is text, then you will need to enclose the value in quotes like this:

If Branch = "3000004" Then
.
.
.

 

[mndrlion]

Also,

You can't disable the control that has the focus.

You should place enable/disable code in the Current event of the form.

 

[masalachol]

mndrlion....Thanks for all your help!!! Milenko