cancel header when 2 values are equal

  • Thread starter Thread starter MNJoe
  • Start date Start date
M

MNJoe

I have 2 text boxes PO_Order_Qty and PO_Received_QTY. When the PO_Order_Qty
is less than or equal to the PO_Received _Qty This line has been totally
received and I want to suppress the output of the line. In the
"Groupheader1_Format" event I put in the code "Cancel = Me.PO_Order_Qty.value
= Me.PO_Received_Qty.value" and it comes up with the runtime error "You
entered an expression that has no value". When I am typing in the
"Me.PO_Order_Qty." the "Value" does not come up as a selection. Can someone
explain the format of this line and what can be used for expressions.

Thanks
 
I just looked at another report. The control source for the PO_Order_Qty is
"Sysadm_Purc_Order_Line.Order_Qty". Is this considered to be text instead of
a value. In the table it is a value. If so how can I set this to a value in
the text box?
 
Back
Top