How do I express a combo box column reference in a query criteria?

[efandango]

I want to tell the query that I want a specfic column on a form's combobox.

This is my current criteria:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point]

I want to say it is:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point].Column(2)

but Access reports invalid bracketing. What am I doing wrong?

 

[Marshall Barton]

I want to tell the query that I want a specfic column on a form's combobox.

This is my current criteria:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point]

I want to say it is:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point].Column(2)

but Access reports invalid bracketing. What am I doing wrong?

Actually, that's Jet that does not recognize that syntax.

Create a little public function in a standard module to get
the column's value:

Public Function MyGetCol(N As Integer)

MyGetCol=Forms!frm_Runs!frm_Getrounds.Form!cbo_copy_to_new_point.Column(N)
End Function

Then you can use MyGetCol(2) in your query.

 

[efandango]

Thanks Marsh,

That worked a treat!

was that the quick and dirty way, or is there a way without having a public
function?

regards

Eric

I want to tell the query that I want a specfic column on a form's combobox.

This is my current criteria:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point]

I want to say it is:

[Forms]![frm_Runs]![frm_Getrounds].[Form]![cbo_copy_to_new_point].Column(2)

but Access reports invalid bracketing. What am I doing wrong?

Actually, that's Jet that does not recognize that syntax.

Create a little public function in a standard module to get
the column's value:

Public Function MyGetCol(N As Integer)

MyGetCol=Forms!frm_Runs!frm_Getrounds.Form!cbo_copy_to_new_point.Column(N)
End Function

Then you can use MyGetCol(2) in your query.

 

[Marshall Barton]

That worked a treat!

was that the quick and dirty way, or is there a way without having a public
function?

The only other reasonable way I can think of is to use a
text box on the form with the combo box's column value and
reference the text box in the query's criteria. Of course,
if you already have that text box, then using it is less
cumbersome.