control source and listbox values

[Rasberry]

My listbox created from a query works without me defining a "control source". Do I need to define a control source? Secondly, when a user makes a selection from my listbox, I want the selection to refer to a different field (tied to that record) and that field will be the "criteria" for additional queries. How do I tell populate the "criteria" via a selection from a listbox and its associated field?

 

[Rasberry]

Yes, it is multiselect.

 

[Norie]

How do you want to use the selected items in the criteria of the query?

Do you want them in an IN clause?

Something like this perhaps:

SELECT *
 
FROM PortfolioPerf
 
WHERE FundName IN (< list of fund names here >)

This would return all records for the fund names in the list.

The list would need to be construct from the listbox.

 

[Rasberry]

Well, I had it coded as "none" and I had it coded as "simple". Neither seems to work as far as recognizing my selection. When I temporarily switched my list box to list only the fund name, the query and criteria still didn't work. So, it must be that the form is not recognizing a "selection".

 

[Rasberry]

Here is my code in the query. Perhaps I should replace "HAVING" with "WHERE". I want the query to sum the record values for all records with the specified fund name. Before, when I just typed in "Galliard Dow Corning" for the criteria, the query worked. But now, I have a reference to my form and the listbox in the form, and it returns nothing. Here is my SQL:

SELECT COMPLIANCE_DATA.DATE, COMPLIANCE_DATA.[Fund Name], COMPLIANCE_DATA.[Compliance Sector 1], Sum(COMPLIANCE_DATA.[BE MKT]) AS [SumOfBE MKT1]
FROM COMPLIANCE_DATA
GROUP BY COMPLIANCE_DATA.DATE, COMPLIANCE_DATA.[Fund Name], COMPLIANCE_DATA.[Compliance Sector 1]
HAVING (((COMPLIANCE_DATA.[Fund Name])=[Forms]![Compliance Reports]![Galliard Portfolios]));

 

[Rasberry]

Aha! I am able to make it work! Norie your orginal instructions worked, I just had to make a couple of adjustments. First, I needed to eliminate the multiselect aspect. Second, I needed to switch around the columns making the field in the list box that was visible was column 2, but the field/column that the criteria kept looking at was field/column 1.

So, in this case, it won't work on multiselect listboxes. .

Thank you so much!!!!