syntax for second column reference please

[Guest]

Could someone remind me how to reference the second column in a list box
when it is being used as criteria.

Forms![form]![data1]?????

thanks in advance.

Ken

 

[Duane Hookom]

One method is

Eval("Forms!frmYourForm!lstBox.Coumn(1)")

Another method is to bind an invisible text box on the form to the column
and then use this text box in the criteria.

 

[Ken Snell [MVP]]

Another method is to use a public function that reads the value from the
combo box's second column, and returns that value from the function.

--

Ken Snell
<MS ACCESS MVP>

One method is

Eval("Forms!frmYourForm!lstBox.Coumn(1)")

Another method is to bind an invisible text box on the form to the column
and then use this text box in the criteria.

--
Duane Hookom
MS Access MVP

Could someone remind me how to reference the second column in a list box
when it is being used as criteria.

Forms![form]![data1]?????

thanks in advance.

Ken