Add records to table using Listbox

[misternumbertwo]

Hi everyone,

Im trying to modify a database that generates invoices. Im having a problem in adding items coming from an ItemsTable to a SelectedItemsTable. Since the numbers of items are too many, i decided to use a search form that will search the ItemsTable for the Item that the user wants to add. The results of the search are propagated in a listbox.

Now, what I want to happen is when a user selects an Item on the Listbox and click a command button (let's say cmdAddThisItem), I want that Item to be added to the SelectedItemsTable. Im trying to use an Update query and setting the "Update to" field to forms!frmSearchAdd!List1 but its not working and I keep getting 0 fields to update.

Can anyone suggest another way to do this? I'm not very well versed at VBA coding yet that's why Im trying to do it this way.

Thanks everyone.

 

[pbaldy]

An update query edits existing records; it sounds like you want to add records. Here's a method, if you're trying to do what I think you are:

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

 

[misternumbertwo]

works like a charm! modified a few codes but it fits exactly what i needed.

Thank you so much Pbaldy!

 

[pbaldy]

No problem, glad it worked for you.