show record from listbox

[cuttsy]

I know that the wizard can set up the show record on form based on a listbox selection but this seems to restrict me on the columns I can show in the list. I tried to edit the row source to include a new column and it doesn't show on the listbox. I am assuming possibly falsely that after using the wizard columns can't be added.

So I created a listbox without the wizard based on a query that shows all of the columns and records that I want it to. Now however the list box obviously does not lookup values on the form.

Can someone please help explain to me or point me in the direction of some info that could help me with the code to perform this lookup without the wizard. Or simply tell me its not possible to do both or indeed that the code is to complicated for someone of a reletivly low ability to implement.

Thanks.

 

[Mile-O]

Set the ColumnCount property of the listbox to show as many columns as you want. Set the ColumnWidths property to determine how wide each individual column is.