I need to make a condition in an mcr with a check box

[cherep]

I have a FrmCreditCard.
and I Have FrmOrder.
I want to make an mcr that it's condition will be such one that if the "pre-paid" field is null (it is a check box) in the FrmOrder, it will open FrmCreditCard.
You see my idea? if you didnt "pre-pay" a credit card form shall open .

 

[perrymans]

Show the conditions column of the macro and add the If Is Null in there. A better way to do it is with code. Depending on when you want it to be checked, just add the:

Dim stDocName As String
Dim stLinkCriteria As String

If IsNull(CheckBox) Then
stDocName = "frmCreditCard"
End If

Also, add another If statement covering whether or not the box is UNCHECKED. If someone checks it, and then unchecks it, it is no long Null, but no stores the 1 or -1 (Ican't remember which one). But you'll want your form to open then too.

Sean.