Hi all,
I’m strugglin on the following matter.
I am asked to create a checklist for a number of tasks to be executed in a particular shift. However in some tasks can be skipped. There are three shifts per day.
To accomplish this i have created a continious form with a number of checkboxes per task which represent the days of the week. The tasks itself are stored in a seperate table with a checkbox per shift (task settings). If the tasks must be performed in a particular shift, the checkbox is activated (= true).
Goal here is, if a task doesn’t have to be executed in a shift the task should not be visible on the continious form. The recordsource of the continious form is a query, which contains a join between the table with the task settings and the table with the tasks performed.
I have placed some code to perform the task in the form’s current event
In the continious form current event I have placed for every checkbox the following code:
Private Sub Form_Current()
If Me. PerformTaskShift.Value = True Then
Me.MaandagOchtend.Enabled = False
End If
End Sub
However when i execute the code and load the form, not only the checkbox in the row mentioned are set invisible, all the rows are.
Is there any way to set only the checkboxes on the rows mentioned invisible, in stead of all rows?
Any help would be appreciated enormiously.
Greetings,
Roger
I’m strugglin on the following matter.
I am asked to create a checklist for a number of tasks to be executed in a particular shift. However in some tasks can be skipped. There are three shifts per day.
To accomplish this i have created a continious form with a number of checkboxes per task which represent the days of the week. The tasks itself are stored in a seperate table with a checkbox per shift (task settings). If the tasks must be performed in a particular shift, the checkbox is activated (= true).
Goal here is, if a task doesn’t have to be executed in a shift the task should not be visible on the continious form. The recordsource of the continious form is a query, which contains a join between the table with the task settings and the table with the tasks performed.
I have placed some code to perform the task in the form’s current event
In the continious form current event I have placed for every checkbox the following code:
Private Sub Form_Current()
If Me. PerformTaskShift.Value = True Then
Me.MaandagOchtend.Enabled = False
End If
End Sub
However when i execute the code and load the form, not only the checkbox in the row mentioned are set invisible, all the rows are.
Is there any way to set only the checkboxes on the rows mentioned invisible, in stead of all rows?
Any help would be appreciated enormiously.
Greetings,
Roger
