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?

 

[Norie]

If you don't want a control source don't use one.

If youwant to use the value selected in the combobox as the criteria for a field in a query this is the general syntax:

Forms![YourFormName]![YourComboboBoxName]

 

[Rasberry]

This looks like it should work, but the query is not recognizing the selection I've made probably because the selection I've made needs to actually refer to another field and I don't know how to do that.

 

[Norie]

What do you mean exactly?

What field is used for the listbox's RowSource and what field is needed for the query?

How are the 2 fields connected?

 

[Rasberry]

The field in the RowSource is "Portfolio", the field I want to use in the criteria is "Fund Name". These fields are connected in a table.

 

[Norie]

So you have a list of portfolios in the listbox but want to use the fund associated with the selected portfolio in the query?

Or is it vice versa?

 

[Rasberry]

Yes, I have a list of portfolios listed in the listbox and want to use the associated fund for the criteria.

 

[Norie]

So how are the 2 associated/connected/linked/friends?

Are they just 2 fields in the same table?

If they are just change the RowSource to include the Fund Name field using a query:

SELECT Portfolio, FundName
FROM tblPortfolios

Then set the listbox's ColumnCount to 2, BoundColumn to 1 and ColumnWidths to 100;0.

The column width of the 2nd column is 0 to hide the FundName column.

You can change that if you want it to be visible.

That should be it.

When a Portfolio is selected the value returned from the listbox should be the FundName of the selected Portfolio.

 

[Rasberry]

Thanks so much for your help. Still can't get it to work. It is not recognizing my criteria. Maybe the selection in my listbox on the form is not being recognized as a selection.

 

[Norie]

Is it a multiselect listbox?