Hello Everyone!
I'm not very proficient at Access but love it's capabilities. I've tried a few avenues but I think I'm making it harder than it may have to be.
I have a main order form to purchase items from various vendors and the OrderID is auto-populated. A person may choose a vendor and push the button to "View Items" for that vendor. Another form pops up with an listbox of those items and information. What I'm trying to do, is if an item in the listbox is double-clicked, I'd like that item to be transferred to a subform/subdatasheet on the same form where the person can enter the Qty and PurchasePrice. The thing of it is, I need the subform/subdatasheet able to list multiple items when selected from the listbox one at a time. Then I need to store that information in my table tblOrderItems.
I've attached a sample of my database for viewing. What would be the best way to do this? Thanks very much!
I'm not very proficient at Access but love it's capabilities. I've tried a few avenues but I think I'm making it harder than it may have to be.
I have a main order form to purchase items from various vendors and the OrderID is auto-populated. A person may choose a vendor and push the button to "View Items" for that vendor. Another form pops up with an listbox of those items and information. What I'm trying to do, is if an item in the listbox is double-clicked, I'd like that item to be transferred to a subform/subdatasheet on the same form where the person can enter the Qty and PurchasePrice. The thing of it is, I need the subform/subdatasheet able to list multiple items when selected from the listbox one at a time. Then I need to store that information in my table tblOrderItems.
I've attached a sample of my database for viewing. What would be the best way to do this? Thanks very much!