How to add item from listbox into subform order line line entry

[Adam1970]

Hi
I watched a YouTube video titled as per this title.
I currently have a search box in the main form that brings up items. I cannot work out how I select a specific item and get it to add to a continuous form for further manual editing IE adding price & qty etc
Any help will be appreciated.
Thanks


Adam

[ranman256]

dbl-click the item in the listbox will execute an append query:
docmd.openquery "qaAddItem2Cart

the query will add the item in tSupply table to the target tCart table , using the KEY of your current record

like:
INSERT INTO tCart (Key, Itemno)
SELECT forms!fMyForm!txtKey, [itemNo] FROM tItems
WHERE (tItems.ItemNo)=[forms]![fMyForm]!
[listBox]

[pbaldy]

If you want to select multiple items:

http://www.baldyweb.com/MultiselectAppend.htm