how to display multiple fields in a listbox?

[zambam]

hi,

i have written SQL code so that all the members with the surname "jones" are found.

i want to display this in a listbox, so that when the user clicks on the specific record from the listbox, the details will automatically fill into the text boxes on the form.

is it possible to display multiple columns in a listbox? if so, pls help!!

thanks

 

[ColinEssex]

Have a look at my example I posted here.

Its a quicksearch method that shortens a list with multiple fields in a listbox and displays the record when selected from the listbox

Col