May 22 2012, 05:20 AM
I have a continuous form displaying a set of records. I want to be able to select multiple records by clicking an option button for each then perform an action on all chosen records.
Does This Make Sense.
The underlying table could have a field for "selected" however the next time I open the form I would want all items to be deselected.
Is there a work round to achieve this??
May 22 2012, 05:56 AM
It's not possible to do this using an unbound control.
To use such a selection technique (which I do frequently) you have to have a field in a table.
Sometimes I create a separate table which has just a primary key and a yes/no field and I fill this with an append query based on the 'main' table (just copying the primary key) and then include this table in the source for my contiinuous form.
In a multi-user app the 'selection' table is set up in the frontend so each user can make different selections.
May 22 2012, 09:39 AM
You can do this, but as Peter46 has already pointed out, not with an unbound control. If, however, you put a field in the underlying table, then use that field on the form to control selecting which records to do something to, that will work. The user's would select those to which something should be done, click a button to do it, then after completion of whatever is done to the records, an update query could then be used to set the selection field back to Unchecked.