Need help new at Access.

R

Ron

I have a form with a check box that indicates it is accepted. I also have a
print button that prints out a report. I would like to have the print button
no be able to print if the check box is not checked. Can anyone help me with
this.
 
G

Geof Wyght

Ron,
In the click event of the print button try:

If me.chkPrint.value = -1 then
Docmd.OpenReport etc...
Else
Msgbox "Please check the checkbox first."
End If

Geof Wyght
 
C

Craig

if "check box" = -1, then me."print button".enable = false, else me."print
button".enable = true
 
Top