Changing Property depending on another property

[scottappleford]

Hi

I have a date out field and would like to have a tick box that is ticked to say it is not coming back. when this gets ticked it locks the date back in and quantity back in fields, also if it gets unticked then it enables them.

Could someone help me on this?

Thanks

scott

 

[freakazeud]

Hi,
ok, I hope I can follow you.
You want to enable/disable two controls based on a checkbox, right?
So on the on click or after update event of the checkbox you can use something like this:

If Me.YourCheckBox.Value = True Then
Me.YourFirstControl.Enabled = False
Me.YourSecControl.Enabled = False
Else
Me.YourFirstControl.Enabled = True
Me.YourSecControl.Enabled = True
End If

Is that what you want?
HTH
Good luck

 

[scottappleford]

Thanks

Great works fine

thanks