Hello, I have one more issue and its a confusing one. My boss is wanting a field in a separate subform to determine whether or not you can enter data into another field in another subform.
If a user puts an "X" in the "Monday" field of the "SAChallenges" subform then the user cannot enter a time into the "Monday" field in the "StartTime" subform. I am racking my brain, do I use a DLookup?
Another challenge that is presented here is that I am also matching "Standard Action" in the "SAChallenges" subform against the "StartTimeAction" in the "StartTime" subform. Perhaps if I make this a little more logical with an If statement.
I know that is not the actual code to use, but I thought it would help explain what is needed.
I would probably want to lock the field after entering the "X", maybe on lost focus for the Monday field in the SAChallenges subform.
If a user puts an "X" in the "Monday" field of the "SAChallenges" subform then the user cannot enter a time into the "Monday" field in the "StartTime" subform. I am racking my brain, do I use a DLookup?
Another challenge that is presented here is that I am also matching "Standard Action" in the "SAChallenges" subform against the "StartTimeAction" in the "StartTime" subform. Perhaps if I make this a little more logical with an If statement.
If "SAChallenges".StandardAction = "StartTime".StartTimeAction AND
"SAChallenges".Monday = "X" Then
"StartTime".Monday."Locked" where "StartTime".StartTimeAction = "SAChallenges".StandardAction
"SAChallenges".Monday = "X" Then
"StartTime".Monday."Locked" where "StartTime".StartTimeAction = "SAChallenges".StandardAction
I know that is not the actual code to use, but I thought it would help explain what is needed.
I would probably want to lock the field after entering the "X", maybe on lost focus for the Monday field in the SAChallenges subform.