Referencing a specific list box column from a query

[Brian Martin]

PARAMETERS [Forms]![frmChoose]!

• .[Column(1)] Text ( 255 );
  SELECT [Product List].[Part Number], [Product List].[Short Description], [Product List].[Full Description]
  FROM [Product List]
  WHERE ((([Product List].[Part Number]) Like " [Forms]![frmChoose]!
  • .[Column(1)]*"))
    ORDER BY [Product List].[Part Number] DESC;
    
    I'm trying to reference the first column in my listbox from my query and the above sql is what I have. This doesn't seem to work. What is wrong with it? Am I referencing it properly?

 

[Tay]

Could you not reference it by using the actual field name which appears in column 1 rather than the column number?

 

[Brian Martin]

worth a try

worth a try but it didn't work either. anybody anymore ideas

 

[Rich]

The first column is actually column(0)
referenced as [ListBox].[Column](0)

 

[Brian Martin]

I found that out thanks anyway. I think the problem might be with the Like "parameter*" part.