N
neenmarie
I have a form for receiving items shipped to the company. It has a master
form with the Date, Vendor ID and Vendor Shipper Number. A subform has a
list box that is requeried by the Vendor ID to show only open purchase orders
from that vendor along with the p.o.#, item and balance left on the p.o.
When clicked, the list box populates the subform with the item number, p.o.
number. The user then fills in the quantity being received.
Because of the way the vendors packages and ship the same items more than
once on the same shipper (and often try to ship more than ordered), what I
need to do is have the list box update with the new balance on the p.o. so
the user knows whether or not to accept an entire truck load or reject part
because it is over shipped for the p.o.
I've tried to 'requery' the list box again with 'lost focus' from the
quantity field, but it didn't work. Ideas of the best way to accomplish this
would be very appreciated.
form with the Date, Vendor ID and Vendor Shipper Number. A subform has a
list box that is requeried by the Vendor ID to show only open purchase orders
from that vendor along with the p.o.#, item and balance left on the p.o.
When clicked, the list box populates the subform with the item number, p.o.
number. The user then fills in the quantity being received.
Because of the way the vendors packages and ship the same items more than
once on the same shipper (and often try to ship more than ordered), what I
need to do is have the list box update with the new balance on the p.o. so
the user knows whether or not to accept an entire truck load or reject part
because it is over shipped for the p.o.
I've tried to 'requery' the list box again with 'lost focus' from the
quantity field, but it didn't work. Ideas of the best way to accomplish this
would be very appreciated.