Selecting multiple rows to perform a function on a form

[jmhooten]

I have a form that uses a query as datasource, and I would like to be able to
select multiple rows from form and then click a button to perform a function.

Any quidance

 

[KARL DEWEY]

One way would be to add a Yes/No field to the table, in the query, and on
form to tick those to perform the function on. Then perform function and
update Yes/No field to unchecked.

 

[Marshall Barton]

I have a form that uses a query as datasource, and I would like to be able to
select multiple rows from form and then click a button to perform a function.

A field in the table can cause chaos if you can have more
than one user at a time.

Alternatives are to maintain a separate table with two
fields (one for the PK in the record source and the other
for the check box).

Personally, I think that is awarkward and prefer to use
Albert Kallal's Multi Select Example at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[jmhooten]

Is there any reason that this Albert's code example shouldn't work with
CurrentRecord in place of the ContactID?

 

[Marshall Barton]

The current record does not change just because expressions
are evaluated so, no, that is not possible.

What's the issue? Are you saying that your records do not
have a unique identifier?

Or, maybe you have so many records that you can notice a
performance decline. If this is the case, then use a
parallel table.