Listbox problems

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

im using a listbox with the rowsourcetype as a value list
and i am manually adding data to it that way. however it
seems there is a limit to the length of the string that i
can use for the rowsource, is there anyway around this??

the reason i am using the control this way is i have
multiple queries that i need to show the results from in
the one listbox.

any suggestings would be greatly appreciated.

Thanks,
Ian.
 
I don't understand, if you are showing results from multiple queries as the
Row Source, how is it a value list?

You can set the Row Source to a query and then change it using VBA to a
different query to display a different set of data in the listbox.
 
Back
Top