How do I select 'non-adjacent' records. Window Explorer
lets you use CTRL-Click to select individual specific
records. But I can't figure out to do it in Access
Create a new table with one field corresponding to the PK of the table you
are interested in. When you want to mark a record as selected, copy it PK
to the new table. When you want to see the records you have marked, create
a query with an INNER JOIN on the two tables.
In any case, "adjacent" means nothing in a table, which inherently has no
order unless you specify a field to sort on -- in a query.
And in any other case, it's really not a good idea to try to manipulate
data using a table data sheet. Use a form (use datasheet or continuous
forms if you are addicted to the grid layout), which will give you more
control over appearance, behviour and sorting order. That is what forms are
there for.
Hope that helps
Tim F
