syntax for second column reference please

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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...
 
Back
Top