List box column values retrieval

[Shamli]

Hi


I want to retrieve from a form's list box column 2 values into another form.

I am trying this in the control source . its throwing " undefined functions error"

Forms!FormName!lstbox.column(2)

Please let me know what the error is.

[ranman256]

In the form after update event, put the 2 values into text boxes (hidden or visible)
then you can use the textboxes in queries.
NOTE: in VB, columns start with zero:

lstBox_afterupdate()
   txtName = lstBox.column(1)   'actually col 2
   txtAddr = lstBox.column(2)
end sub

or use the FULL path to the form
forms!myForm2.txtbox2 = me.txtAddr

[pbaldy]

As a control source, you'd need an = at the beginning.

[Shamli]

Thank you. let me try that and see.

In the form after update event, put the 2 values into text boxes (hidden or visible)
then you can use the textboxes in queries.
NOTE: in VB, columns start with zero:

lstBox_afterupdate()
   txtName = lstBox.column(1)   'actually col 2
   txtAddr = lstBox.column(2)
end sub

or use the FULL path to the form
forms!myForm2.txtbox2 = me.txtAddr