Selecting non-continuous records in a continuous form

  • Thread starter Thread starter wvaughan
  • Start date Start date
Do you mean selecting multiple records? As in selecting Record 1, Record 10,
and Record 40?
 
If you mean you want to click on several different records and have them all
active at once (or you want to copy them all at once), the answer is there is
no method to do this.

If you mean you want to mark several different records and then do something
with them there are two methods that I can think of.

Method one: best used in single-user databases
Add a field to the table (usually a checkbox) and show it on your form. Then
use it to add or remove records from the selection. Then use a query or a
filter to choose just the marked records.

Method two:
Add a TABLE (work table) with two (or more fields)
Field1: contains the primary key of the Source Table
Field2: contains an identifier (userid or an arbitrary session value)

Have a button on your form that will add/remove the current record to/from the
work table.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top