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]));"
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]));"