@bknabl Welcome to Bytes :)
In short this bit of your question:-
1. The check boxes do not select individually. If one box is selected, all boxes become selected.
You need to tie in that checkbox to an underlying field of the boolean type ie a Yes/No field in the underlying table by setting its controlsource. The reason they are
'all coming on at once' is due to the fact that you currently have it displayed yes.....but it is not bound to anything.
Once you have made your selections, the easiest method then is to create a simple form that has an SQL query recordsource where records are displayed from the table but restricted to WHERE the Selected field is true and where any 'other' field used on your existing search ie [Spec]="BACS" are also specified as part of that SQL's WHERE clause. Then you simply open the form using whatever logic you wish, either a button or whatever else suits you.
There are various ways however of listing and selecting multiples of records.....you are using a subform but a listbox can also do this and has the added advantage of
'multi select' simple or extended. I suggest you have a look at that feature, if all you are doing is listing and not particularly editing the record 'in place' as you might do directly in a subform, if I am making myself clear.
19
