Using 'column(n)' in a query/SQL

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hi all,

Can some one tell me how I can use the value of a combobox.column(1) in a
query or SQL string?

Like:
Criterea >= [Forms]![frmOverview]![cmbDateRange]!Column(2)

I get the error message 'undefind function in expression'..............

Thx,
Ludovic
 
Hi all,

I made a work-around with a function (below), which i call from the query.
It seems to work the way i needed it.

Function DateValue(Optional intColumn As Integer = 2)
DateValue = Form_frmOverview.cmbDateRange.Column(intColumn)
End Function

Sorry to bother.

Cheers,
Ludovic
 
Back
Top