Hi Guys,
I just wanted to put this one out there again. I have daily forms for the week and they have actions that need to be marked off with checkboxes. Depending on the value of one of my other fields, I want to hide or lock a couple of checkboxes.
If I could even gray them out or anything to sway users from entering a check when they shouldn't.
The appearance on the form is like this
Field1[Action] - Feild2[Tab1] - Chkbox1Yes - Chkbox2No Field3[Tab2]-Chkbox3Yes - Chkbox4No
If there is a value in both Tab1 and Tab2 then I don't need to lock anything.
It's when there is no value in Tab1 that I need to lock Chkbox1 and Chkbox2.
Also, if there is no value in Tab2 then I need to lock Chkbox3 and Chkbox4.
I know conditional formatting doesn't like checkboxes. I am hoping there is a solution. When I tried to lock the boxes with VBA, it locked them for all the records.
Any help would be greatly apreciated.
I just wanted to put this one out there again. I have daily forms for the week and they have actions that need to be marked off with checkboxes. Depending on the value of one of my other fields, I want to hide or lock a couple of checkboxes.
If I could even gray them out or anything to sway users from entering a check when they shouldn't.
The appearance on the form is like this
Field1[Action] - Feild2[Tab1] - Chkbox1Yes - Chkbox2No Field3[Tab2]-Chkbox3Yes - Chkbox4No
If there is a value in both Tab1 and Tab2 then I don't need to lock anything.
It's when there is no value in Tab1 that I need to lock Chkbox1 and Chkbox2.
Also, if there is no value in Tab2 then I need to lock Chkbox3 and Chkbox4.
I know conditional formatting doesn't like checkboxes. I am hoping there is a solution. When I tried to lock the boxes with VBA, it locked them for all the records.
Any help would be greatly apreciated.