Windows XP Using selected items in a listbox for append query

P

pdsasse

Joined
Jan 8, 2006
Messages
1
Reaction score
0
I have an unboud list box. I want to set it up so the user can select multiple items in the list, then click a button to have the selected items appended to a table. I've tried several things (see below) and it isn't working. Thank you in advance for any help you may have.

SQL examples of what I've tried.

"INSERT INTO Lead_Emp_Join ( LeadID )
SELECT [Forms]![Assign_Leads]![NewLeads] AS LeadID;
"

"INSERT INTO Lead_Emp_Join ( LeadID )
SELECT Leads_All.LeadID
FROM Leads_All
WHERE (((Leads_All.LeadID)=[Forms]![Assign_Leads]![NewLeads]));"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
Select from list box and enter selection in a table. 1
Redemption Data Object - How do you get a static list of message items in the Inbox for looping? 1
Using VBA to select Items in multiselect Listbox 1
Listbox selected count 3
append query based on items selected from list 3
append query with listbox criteria 2
Access Determine what query to run based on a checkbox 0

Top