Append Query running from a listbox

[sud2017]

Hi Experts,

In my form, I have a listbox containing various opportunities, which are, once selected, append records for different OppIDs to a table.

User selects multiple opps (one at a time) from the listbox. Originally, I was desiring for somethig like multivalue checkboxes but read in forums that it is problematic.

Currently user selects each opp individually and then click save button (to run append query for that opp) but this is bit time consuming as i have many opps in the listbox.

I also tried running append query from on-click event of listbox, so everytime user selects an opportunity, values are appended without clicking save button (to run append query) each time. This was working fine for sometime until it started showing an error message of key violations, so i have switched back to the single opp select and save approach, which as I said is really time consuming.



Your advise to best approach this would be greatly appreciated. Thank you.

[pbaldy]

How about:

http://baldyweb.com/MultiselectAppend.htm

[sud2017]

Thanks Paul. Looks like it will involve some coding. I have data appending from 2 tables and one user entered value appending from a FORM (same form where i am running the query), hence the code might get a bit complicated,considering my lack of coding knowledge.

Currently I am running Append Query from OpenQuery macro. Before I really get into the coding as shown in your attached database, I am curious if there is any way to accomplish multiselect listbox to append record with my current Query and Macro based setup?

Your time is much appreciated.

[pbaldy]

I don't see how. Code is required to get the selected values from a multiselect listbox.

[sud2017]

Thanks again Paul. I will be digging into the code part soon and will request for help if there is any issue. Greatly appreciate your help.

[pbaldy]

No problem, post back if you get stuck.