Hi all,
I have a report for purchase orders. In the report, there is a checkbox (control source is OrderItemBarcode). If the item on a line is a chemical, the box gets checked as needing chemical inventory barcoding. I have a label on the report (lblProcessForBarcode) at the top of the form set as "Visible=No". If one or more of the checkboxes on the report are checked, the label should be visible. I thought I could just do something simple in the Current event of the report, but no. Of course, because it's Friday afternoon. This is what I have so far:
If Me.OrderItemBarcode = True Then
Me!lblProcessForBarcode.Visible = True
Else:
Me!lblProcessForBarcode.Visible = False
End If
Any assistance will be greatly appreciated.
I have a report for purchase orders. In the report, there is a checkbox (control source is OrderItemBarcode). If the item on a line is a chemical, the box gets checked as needing chemical inventory barcoding. I have a label on the report (lblProcessForBarcode) at the top of the form set as "Visible=No". If one or more of the checkboxes on the report are checked, the label should be visible. I thought I could just do something simple in the Current event of the report, but no. Of course, because it's Friday afternoon. This is what I have so far:
If Me.OrderItemBarcode = True Then
Me!lblProcessForBarcode.Visible = True
Else:
Me!lblProcessForBarcode.Visible = False
End If
Any assistance will be greatly appreciated.