using listbox to populate variables

[MattBegg]

Hi

I am using a listbox which displays the contents of a table, I am looking for a way to select an item in the listbox and based on the item selected populate variables with the contents of the table based on the selected field.

How could I do this ??

Regards

Matt

matt@begg-uk.co.uk

 

[RickSpr]

Load all the fields you need from the table into additional columns in the list box, and set the Column Widths property to hide the extra columns. In the AfterUpdate event, use the Columns property of the list box to retrieve the values and assign them to controls. Rick Sprague

 

[MattBegg]

thanks RickSpr Regards

Matt

matt@begg-uk.co.uk