list box population

[samjesse]

Hi

Thanks in advance for helping with this problem.

I have a Continuous Form with data from table items (ItemID is the Key), on the form I have an Unbound list with Row Source being a SELECT from a table Prices, the SELECT has Criteria under ItemID field to match the form itemID control value.

I am not getting what I expect which is a list of prices for each item.

Regards

 

[rzw0wr]

Please paste your Row Source data for us to look at.

Dale

 

[samjesse]

Please paste your Row Source data for us to look at.

Dale

SELECT [tblPrice].[ID], [tblPrice].[SupplierID], [tblPrice].[ItemID], [tblPrice].[price] FROM tblPrice WHERE ((([tblPrice].[ItemID])=[Forms]![frmItems]![itemID]));

 

[samjesse]

Please paste your Row Source data for us to look at.

Dale

SELECT [tblPrice].[ID], [tblPrice].[SupplierID], [tblPrice].[ItemID], [tblPrice].[price] FROM tblPrice WHERE ((([tblPrice].[ItemID])=[Forms]![frmItems]![itemID]));

 

[JHB]

Hi
...
I am not getting what I expect which is a list of prices for each item.

What are you then getting?

If you only want the price to show in the list then use, (else you'll get a 4 column list if you use your shown query):

SELECT [tblPrice].[price] FROM tblPrice WHERE ((([tblPrice].[ItemID])=[Forms]![frmItems]![itemID]));

 

[samjesse]

I am getting an empty list with my solution or with yours.

 

[jdraw]

If you open the tblPrice, do you see ItemIds and Prices.
Can you use the filter on the User Interface to select only specific ItemID?

 

[samjesse]

If you open the tblPrice, do you see ItemIds and Prices.
Can you use the filter on the User Interface to select only specific ItemID?

Ahh.
No. I did forget to mention something important.
The itemID in tblPrice is a combo box with bound column = 2 and data from
SELECT [tblItems].[Name], [tblItems].[itemID] FROM tblItems ORDER BY [tblItems].[Name];