Select multiple non-sequential records in continuous form

Question

All

I have a continuous form which is linked to some table.
For e.g.

1. Book
2. Dog
3. Cat
4. Fish
5. Pen

If I press on the "records selector" of record 2, press Shift and then press on the "record selector" of record 4, the result is that records 2, 3 and 4 are selected.

But how can I select non-sequential records? e.g. I want to select record 2 and 5. I expected this could be done with the CTRL-key, but only the last record I press on is selected.

Answer 1

What is the purpose of this? As thedbguy said, having a Boolean (Yes/No) column in the table, and a check box control in the form bound to the column, would enable you to 'select' multiple rows. You could then use an SQL statement to manipulate the data in the 'selected' rows, if that's what you are attempting, or you could use conditional formatting to identify the rows visually.

More information about the desired aim would help us advise you further.

Answer 2

One possible approach is to add a Yes/No field to your table and use the checkbox in your form to "select" the records you want. Just a thought...