Combo column reference in a query

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?
 
K

Ken Snell \(MVP\)

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()
 

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

Similar Threads

Access #Error & Excel Pivot 0
Date expression in Query 4
referring to a combo box column as criteria in a query 5
Setting Fieldname in query with a combobox 6
Access Query problem 1
Undefined function 'Left' in expression 2
Pull Column 1 from a combo Box and display in a Query! 5
Query IIF function 3

Top