D
Derek
Hi all
I want to choose a supplier "Staples" look through previous orders placed
with "Staples" and when selected add the item to the new current order.
I have created a form that lists all of the items previously ordered from a
selected supplier ("Staples"). I want to select an item (or record) and have
its current selection/record used as criteria for an append query to add the
selected item to the Purchase order table. Can I use current record as
criteria? or is there a better way?
Thank you.
I want to choose a supplier "Staples" look through previous orders placed
with "Staples" and when selected add the item to the new current order.
I have created a form that lists all of the items previously ordered from a
selected supplier ("Staples"). I want to select an item (or record) and have
its current selection/record used as criteria for an append query to add the
selected item to the Purchase order table. Can I use current record as
criteria? or is there a better way?
Thank you.