[AccessD] A2K Reference the dot column property in a query

Darren DICK d.dick at uws.edu.au
Thu Sep 4 22:34:50 CDT 2003


Hello all
In VBA the code to reference certain columns in a combo box on a form is...
Forms!frmMyForm!cmbMyCombo.Colum(2)  - Cool it all works
But when I use the same syntax in a query I get errors - namely
Undefined function '[Forms]!frmMyForm!cmbMyCombo.Column' in expression

What should I type to reference a particular column of a combo in a query?

Many thanks in advance

Darren




More information about the AccessD mailing list