Query Results In Listbox to Textbox.

[Infiltrate82]

I got one for you...I have a textbox that a user puts in a number. this number is then ran against a table and the query results are displayed in a listbox. I then want the columns in that listbox to be put into several text boxes automatically. I have this working if i click on the listbox but the way that this table is searched there can only be one result and i would like the query results being displayed in that listbox to automatically show up in the textbox. Is there something i can do with the rowsource that will automatically select a row?


Cpl Shutts

 

[Dennisk]

one of the methods of a list/combo box is the index wich is the row selected. So try going the other way and selecting the data from a list box using the column*() method to extract the columns and the index to refer to the first row. There are alternative method using a function to run the query and a UDT to return the value of the columns or an array which can then be used to populate the various text boxes.