I am running the following code in the On Close event of a report. When the user selects "Yes", I get the following error message:
"Run-time error '-2147352567 (80020009)';
You can't assign a value to this object."
Private Sub Report_Close()
'Completes clinic for reconciliation and _
printing of claims.
If Me.ClinicReconciled = -1 Then
ElseIf Me.ClinicReconciled = 0 Then
If MsgBox("Is this clinic reconciled?" & Chr(13) & Chr(10) & _
"Are claims ready to print?", vbYesNo, "Print Claims") = vbNo Then
Me.ClinicReconciled = -1 <----This is the line that is highlighted when I select "Debug".
How can I enable the control "ClinicReconciled" to be updated when the user selects the Yes option of the message box?