Selecting multiple rows to perform a function on a form

  • Thread starter Thread starter jmhooten
  • Start date Start date
J

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
 
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.
 
jmhooten said:
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.
Click to expand...


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
 
Is there any reason that this Albert's code example shouldn't work with
CurrentRecord in place of the ContactID?
 
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.
 
Back
Top