Configuring a combobox (please help)(newbie)

[Guest]

I currenly have a combobox that i select the product name from a list in
order to bring it up to do some calculations (based on the northwind
databse). but the product name is the same as a couple of the specs put
together so i switched it to do this:


I used to have this code in a combo box to bring up the specs on a product

SELECT DISTINCT Products.ProductID, Products.ProductName FROM Products ORDER
BY Products.ProductName;

But then i switched to this and now not all the products come up on the
list, also after i make the selection, it shows in the combobox the
"productname", because i want it that when i enter the products i can now
ingnore the product name.


SELECT DISTINCT [Order Details Extended].ProductID, [Order Details
Extended].[PipeType NPS], [Order Details Extended].[NPS Designator], [Order
Details Extended].[Pipe Finish], [Order Details Extended].PipeLength FROM
[Order Details Extended] ORDER BY [Order Details Extended].[PipeType NPS];


Any help would be greatly apreciative.

 

[Van T. Dinh]

The new RowSource will only show Products that have *previously* been
ordered if that's what you want.