Add item to transaction table?

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

I have a somewhat ordinary Purchase order with a header form and a subform
for detail line items. I would like to be able to add items to the detail
by opening another form of all available items and selecting one item at a
time. As each is selected they need to be added as line items on the
purchase order. I have all of the components but can't figure out how to
add a new PO Detail record with the item number of the selected item. Can
someone point me in the right direction?



Thanks for the help!
 
Why can't you use the combo box functionality in your
details form to select the items that you want to add to
the order? Have it query the source that contains the
items you're selling.
 
A list box would work for selecting a customer on the header form but on the
subform with single line items, a list box with scroll bars for a few
thousand items would be unwieldy. That is why I wanted to try a second
form.
 
Back
Top