Totalling cells

[ryetee]

OK understand the way this list box would work but don't think it fits in with the design I currently have.

He'll have to do with the solution provided by MajP (thank you again). If he's not satisfied what I could do is add another yes/no field to the table. If he selects it then I can sum on that and display in the filter. I presume I can't use an unbound field. I'd then need to clear the field before updating somehow.

 

[MajP]

I presume I can't use an unbound field. I'd then need to clear the field before updating somehow.

Yes it would have to be a yes not field in the table. To clear the field you simply do an update query.

Update TblName Set YesNoField = False

So you could do a combination of the two. You could use the code I provided to mark the records as True. Then you could manually pick some more. And if you wanted another non contiguous range you could select some more. Then using conditional formatting it would make the rows look selected.

 

[pbaldy]

To make sure you're aware, if you have multiple users doing this at the same time, the yes/no field won't work (not without modification anyway).

 

[MajP]

Yes, did not think of that. If multiple users, and you want the yes/no, then you would need a local table to each user that stores the ID of the selected fields.

 

[ryetee]

OK I think I know what I'm doing.
There are multiple users but they look at their 'own' data so shouldn't be a proble.