I have a form with a checkbox and also with an attachment field. If there is no attachment then I want the checkbox to be false. If there IS an attachment I want the checkbox to be true.
I've tried this but it doesn't work. The checkbox is checked no matter what.
If IsNull(Me.picScannedIDcard) Then
Me.chkbxHasAttachment = False
Me.chkbxHasAttachment = True