table in listbox

[a.mlw.walker]

Hi is it possible to have a table in a list box with all the relevent fields included? how would i go about this.

thanks
alex

 

[neileg]

If you only want to have have one field in the list box, yes. Use the table or a query based on the table as the row source. If you want to have more than one field in a list box, use a combo box instead.

 

[a.mlw.walker]

Thanks for that, I have a search buttong on the form, that finds a field, from a textbox and puts the info into the form, the name of the company into a textbox control. Can i get the list box to scroll to the name in the listbox, that is in the other textbox.
And B, The field I am interested in is the fifth column. How can i get just that one to appear.

Thanks

 

[neileg]

Instead of your text box search, I would use a combo box. The native behaviour of a combo is that it zooms to a value as you type. The relevant data you need can then be taken from the column in the combo box.