syntax for second column reference please

K

Ken

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
 
D

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

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>

Duane Hookom said:
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


Ken said:
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
Click to expand...
Click to expand...
 
Top