Continuous Form - Listbox

[boblovesyousomuch]

Hi,

I have an SQL statement that brings back many records. For each record it brings back i would like it to populate the listbox using some other SQL I have passing the unique id for that record in to it.

How can i do this (if it can be done)?

I hope that makes sense.

Cheers

--------------------
Carl

 

[SeeThru]

If the SQL is a query that returns the lines you need, you can set the source of the listbox to this. Make sure the data you want to save is the first column, and any fields that are used for selection only are not shown.

You na also write a function that fills a list box, usually using a loop to find every X in Y or whatever. I'd have to check details as I havent done it for a while.