Take a real life example: I enter a customer payment and display a list of
open invoices for that customer. I now want to 'tick' (toggle) each invoice
line that is being satisfied by the payment. Another example: I display a
list of players and want to 'tick' those that will form next weekend's team.
I have solved this in the past by including a dummy selection column on the
table itself or, if there is a complex query, by building a new table that
includes the dummy column and then binding the form to that table.
Any thoughts?
Regards,
Rod
If this is something you're going to do, you've found the answer. Add a
field to the table for this selection. You can simply ignore the field when
you don't need it (i.e. in other queries of the table, etc). You can also
just hide this control on the form if you don't want to see it all of the
time. When you're finished checking the desired rows and run whatever
routine you're going to run, then run an Update Query to set all the rows
back to unchecked (False) so that your selection form will be ready for the
next time.
--
Wayne Morgan
MS Access MVP
"Rod Plastow" <RodPl...@discussions.microsoft.com> wrote in message
news:146AD108-BB77-4A57...@microsoft.com...
You describe more or less how I have always handled this requirement but it
has always seemed a little inelegant. At least I now have the comfortable
feeling that I'm right.
Regards,
Rod