T
Tom A
I have a Purchase Requisition that as all multi lines
items on the Purchase Requisition subform have been
received I want a field on the main form of the Purchase
Requisition called STATUS to change to ORDER COMPLETED. I
have tried to use a macro and a VB. I want the changes to
happen automatically. I tried putting the trigger to
happen on the ON LOAD in the form properties. The only way
that it happens fast and clean is to use the RUN button on
the Macro. I did an update in a query and it causes the
changes to be make but not through the individual Purchase
Requisition. I want each Requisition to be closed if there
are 10 items ordered and received on just that
Requisition. Is this clear as mud?
items on the Purchase Requisition subform have been
received I want a field on the main form of the Purchase
Requisition called STATUS to change to ORDER COMPLETED. I
have tried to use a macro and a VB. I want the changes to
happen automatically. I tried putting the trigger to
happen on the ON LOAD in the form properties. The only way
that it happens fast and clean is to use the RUN button on
the Macro. I did an update in a query and it causes the
changes to be make but not through the individual Purchase
Requisition. I want each Requisition to be closed if there
are 10 items ordered and received on just that
Requisition. Is this clear as mud?