Combo column reference in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the following error message --
Undefined function '[Forms]![CTK_Assigned]![Combo23].Column' in expression.
when I use this in a query --
Expr1: [Forms]![CTK_Assigned]![Combo23].Column(0)

I am using Access 2002 SP3.

Any suggestions?
 
You cannot read the .Column property of a combo box from a query. Instead,
create a public function that will read the desired column from the combo
box, and then call that function in your query:

Public Function GetColumn0OfCombo23() As Variant
GetColumn0OfCombo23 = [Forms]![CTK_Assigned]![Combo23].Column(0)
End Function


Expr1: GetColumn0OfCombo23()
 
Back
Top