Easy code - dumb question but need help

eholtman

Registered User.
Local time
Today, 06:49
Joined
Oct 12, 2004
Messages
54
Private Sub Billing_Reconciled_Click()

If [Billing_Reconciled] = True Then
[Billing_Date] = Date

End If

If [Billing_Reconciled] = False Then
[Billing_Date] = Null

End If
End Sub


Simple code but I am having issue with other users that are being rejected when access this code. Can this be cleanned up?

Thanks
 
How about...

If [Billing_Reconciled] = True Then
[Billing_Date] = Date
else
If [Billing_Reconciled] = False Then
[Billing_Date] = ""

End If
End Sub

Is the "True" Yes/No if not that is another thing to check out.
 
Check for missing references.
 

Users who are viewing this thread

Back
Top Bottom