Hi all,
I have a subform with Unbound CHECKboxes. When clicking them my table is updated correct.
The problem is that when I open the subform the next time for the NR on the head form, all my CHeck boxes are set to FALSE, but I want them to have the value that is stored in the table.
So I thought I do the following:
===========================
If PROJNR_SK <> Null Then
MR_11 = DLookup("ActiviteitJN", "Activiteitenlijst", "ACTNR_SK = 3001 And PROJNR_SK = " & Me!PROJNR_SK)
If MR_11 = True Then
Selectievakje31 = True
End If
End If
===========================
The PROJECT_NR gives me the correct number and the lookup gives me TRUE, but in my form the checkbox "Selectievakje31" still displays FALSE.
What am I doing wrong.
Thx in advance for your time and help,
Steven.
I have a subform with Unbound CHECKboxes. When clicking them my table is updated correct.
The problem is that when I open the subform the next time for the NR on the head form, all my CHeck boxes are set to FALSE, but I want them to have the value that is stored in the table.
So I thought I do the following:
===========================
If PROJNR_SK <> Null Then
MR_11 = DLookup("ActiviteitJN", "Activiteitenlijst", "ACTNR_SK = 3001 And PROJNR_SK = " & Me!PROJNR_SK)
If MR_11 = True Then
Selectievakje31 = True
End If
End If
===========================
The PROJECT_NR gives me the correct number and the lookup gives me TRUE, but in my form the checkbox "Selectievakje31" still displays FALSE.
What am I doing wrong.
Thx in advance for your time and help,
Steven.