populate multi-select text prompt with data item

[irvingbos]

I am trying to run a report when a record is entered into a table. One field in the record will have data to be used to populate a mutli-select text prompt (called  which_IDs)  in the report. Is this possible? It works fine when running interactively. The event also trigges fine when a record is added to table, but the report always reports "no data avaialable'. The data in the record is comma-seperated, and the filter on the query in the report is  ID in ?which_IDs?. Any one have success doing this?

thanks for any suggestions!

[irvingbos]

SOLVED: change filter on query to :
[ID] in (#csv( split(',', prompt('which_IDs','token')))#)