Ok I tried the following code:
Code:
If Me.Van_15_PAX_ = -1 Then
Van_15_PAX_.Visible = True
Else
Van_15_PAX_.Visible = False
End If
Code:
If Me.Bus_48_PAX_and_Below_ = -1 Then
Bus_48_PAX_and_Below_ = True
Else
Bus_48_PAX_and_Below_ = False
End If
and it worked with the Van but not the Bus; it comes back with this error: runtime error '-2147352567 (80020009)': You can't assign a value to this object. I have 92 check boxes with similar equipment to add to this code. Also, when it does work it leaves the blank space between the fields on the report; I need all of the checked data to line up properly on the report.
Thank you so much for any help with this! I am on a time crunch to get it done for my boss.....