Using checkbox to select records to add

  • Thread starter Thread starter RussCRM
  • Start date Start date
R

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?
 
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?
Click to expand...

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.
 
Is there another way?
Click to expand...

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!
 
Back
Top