check box, you can't print this form unless..

[Carol Shu]

Good Morning All,
I would like to set up this..for the database user.
there is a "Finance" check box, and many forms to be print, if user didn't
check the "Finance" box, I would like something to pop up on the screen
like...[you can't print this form "payment", unless the "finance" check box
is checked], could someone help me, please, and many thanks.

 

[joecosmides]

If you are using a button that must be clicked to print the form then:

Add this code to the On Click event under "Events" of that button.

If Not Me.Finance Then
MsgBox "You must Check the Finance check box.", vbOKOnly,
"Message!"
Exit Sub
End If

 

[g]

Hi Carol,

If your form has a botton to print the form you can put in your click event

If Me.YourFinanceCheckBoxControlName <> -1 Then
MsgBox "You can't print..."
Exit Sub
End If
Otherwise do the print botton thing.

 

[Carol Shu]

thank you gentleman, for the quick response.
the PromNoteForm is a command button, and has a on click [embedded macro],
is there any other way to do this, if user did not check the [finance] box,
can a mesage appear like "you can not print this form..unless you check the
FINANCE box? thank you.

 

[g]

Add additonal column in your macro which is "condition" and on the first row
of your macro type in.

Conditon:
FinanceCheckBoxName <> -1

Action:
MsgBox

At the bottom left where it say "message" type your message.

thank you gentleman, for the quick response.
the PromNoteForm is a command button, and has a on click [embedded macro],
is there any other way to do this, if user did not check the [finance] box,
can a mesage appear like "you can not print this form..unless you check the
FINANCE box? thank you.

If you are using a button that must be clicked to print the form then:

Add this code to the On Click event under "Events" of that button.

If Not Me.Finance Then
MsgBox "You must Check the Finance check box.", vbOKOnly,
"Message!"
Exit Sub
End If

 

[g]

Before I forgot also put on condition on print: FinanceCheckBoxName=-1

Add additonal column in your macro which is "condition" and on the first row
of your macro type in.

Conditon:
FinanceCheckBoxName <> -1

Action:
MsgBox

At the bottom left where it say "message" type your message.

thank you gentleman, for the quick response.
the PromNoteForm is a command button, and has a on click [embedded macro],
is there any other way to do this, if user did not check the [finance] box,
can a mesage appear like "you can not print this form..unless you check the
FINANCE box? thank you.

If you are using a button that must be clicked to print the form then:

Add this code to the On Click event under "Events" of that button.

If Not Me.Finance Then
MsgBox "You must Check the Finance check box.", vbOKOnly,
"Message!"
Exit Sub
End If