Getting CmbBxColumn from within query

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
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top