A form has a yes/no check box, this check box is the indicater to show if a particular job is a maintenance or a production job and when that particcular job is completed by either department, on another form a yes/no check box is activated to show the job is completed. The event most turn the yes/no button on the first form off. How do I do this.
You wouldn't want to deal with this by setting the value of the
checkbox across multiple forms. What you want to do is have the
checkbox bound to the field that stores the completed status.
Then if you check/uncheck it, any other forms will also know it's
status.
Now, if your first form isn't bound to your job table, you're going to
have to write code which:
1) Check the value stored in the table for whatever the current job is
2) Enable/Disable the button each time a new job is selected
3) Store the completed status in the table after clicking an enabled
button
4) Disable the button after setting it as complete.
I'm not sure of your application design and your explanation of
needing two forms to accomplish the task, so this is just a guideline.
-D
