Getting CmbBxColumn from within query

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

I suppose I can't get a specific ComboBox column from within a query
as
Criteria: Like [Forms].[FormName].[ComboBoxName].[column(6)]

Right?

A function solves the problem, but If I can do it just from withing
the query, so much the better.

Henry
 
H. Martins said:
I suppose I can't get a specific ComboBox column from within a query
as
Criteria: Like [Forms].[FormName].[ComboBoxName].[column(6)]

Right?

A function solves the problem, but If I can do it just from withing
the query, so much the better.

No. SQL does not recognize the argument as part of a
property reference. Use the function.
 
Back
Top