Modifying a list based on a query

[Movian]

So I have a data set based on a query that I need the user to be able to edit.

Essentially I have a query that gets a list of patients that need a statement to be generated and I display this in a listbox with the query as the rowsource.

I now would like to allow the user to remove items from the list (remove patients they don't want to send statements to) however it appears that I can only do this if the listbox is set to a value list.

However the list box appears to be a 'Snapshot' of the results of the query so I would have thought the workflow I had in mind would work.

Just checking if I am missing something before I create a function to pragmatically enter the values returned by the SQL query as list items which will be mildly annoying.

[Movian]

Never mind I found a way that works and adds an extra feature at the same time.

I added a second list box with the "removed" items and then add a function that cycles through that list and for each item adds an exclusion to the logic of the query that populates the main box.