T
Tom
I have a subform called POLINE that has a Quantity Ordered (qtyord)and a
Quantity Received (qtyrec). If qtyord<=qtyrec I want a field called Status on
the main form to change to "Parts Received". I have made two fields in POLINE
table called "ordsum" and one called "recsum" I thought I could sum qtyord
and qtyrec and compare them and if ordsum<= recsum I could get the Status to
change. I don't know how to write a vb statement and where to put it to get
all of the past records to change.
Quantity Received (qtyrec). If qtyord<=qtyrec I want a field called Status on
the main form to change to "Parts Received". I have made two fields in POLINE
table called "ordsum" and one called "recsum" I thought I could sum qtyord
and qtyrec and compare them and if ordsum<= recsum I could get the Status to
change. I don't know how to write a vb statement and where to put it to get
all of the past records to change.