seperate cell values

[spinkung]

hi

i have a table which contains report definitions. rpt_id, rpt_name, rpt_col1, rpt_col2, rpt_col3, ..... (there is some other stuff)

so a cell in rpt_col1 will have maybe account numbers stored in a string in, so: 5001, 5002, 5003


i want to be able to load in a report def so i need to set the list box selections based on the cell value.

ie. select all items in my account number list that match the above.

whats the best approach to splitting out the text so i can say something like....


for each item in mylistbox
if item.text = MyCellValue (5001 in the first case)
item.select


is this even possible..?

thanks

 

[llkhoutx]

Have a query that is the recordsource for your report. Rebuild the query (i.e. the querydef.sql) with each new selection.