Re: Selecting non-continuous records in a continuous form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

wvaughan wrote:
What is the best method to select non-continuous records in a continuous form?
.

Relevant Pages

  • Re: Creating a table with multiple key and boolean fields in SQL
    ... CREATE TABLE ThirdTable (Field1 TEXT, Field2 TEXT, Field3 INTEGER ... CONSTRAINT MyFieldConstraint PRIMARY KEY );(example is VBA, ... > key and integer and boolean fields. ...
    (borland.public.delphi.database.ado)
  • Re: multiple field, primary key
    ... field3 text ... The primary key is the foreign key in several other tables. ... enters field1, field2, field3, and the afterupdate event of each is: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: multiple field, primary key
    ... field3 text ... The primary key is the foreign key in several other tables. ... enters field1, field2, field3, and the afterupdate event of each is: ...
    (microsoft.public.access.tablesdbdesign)
  • multiple field, primary key
    ... field3 text ... The primary key is the foreign key in several other tables. ... enters field1, field2, field3, and the afterupdate event of each is: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to find Minimum of four fields
    ... SELECT Id, Field1, Field2, "PhoneCost" AS CostType, PhoneCost AS CostAmount ...
    (microsoft.public.access.gettingstarted)