Selecting records from a query

[Guest]

Is there a way to select (from a form) specific records
from the results of a query? For example, using a check
box?

I would like to search for records from a form, then
display the results of the search in a subform, then
select certain records from the subform for further
processing.

Thanks!

 

[Steve Schapel]

Probably the easiest way to do this is to actually include a new Yes/No
data type field into the table that the query is based on, and use this
to select your records. Whatever is involved in your "further
processing", you can use an Update Query to set the value of this field
to Yes or No as required for all records, either before or after, so
that you are starting with a "blank slate".