Using checkbox to select records to add

[RussCRM]

Is there a way to use a checkbox on a form to select which records you
want to include in a report or append query? I don't want to tie them
to a table because I don't want to keep the checkbox data after I'm
done. Is there another way?

 

[fredg]

Is there a way to use a checkbox on a form to select which records you
want to include in a report or append query? I don't want to tie them
to a table because I don't want to keep the checkbox data after I'm
done. Is there another way?

Add a check box field to the table.
Include the new check box field in the form.
For each record you wish to include in your report, place a check in
it's check box field.

As criteria for the report you can then use:
[CheckField] = True

Only records that have been checked will appear in the report.

After the report is run, you can run an Update query to return all the
check boxes to unchecked (false).

Update YourTable Set Yourtable.CheckField = false

You're now ready for the next session.

 

[John W. Vinson]

Is there another way?

Not really, no. You can have a Yes/No field in the table that you're reporting
from, or in a table joined one-to-one to that table. But you can't have a
bunch of checkboxes floating in midair not attached to anything!

 

[RussCRM]

Thanks guys! This helped! I appreciate it!