Solved Select records and then feed them to a report

[cheberdy]

I have a form and wanted to make it possible for the user to select the records at will and then submit them to a report. However, I do not know how to make this possible for the user. The best would be like checkboxes on each record.
Does anyone have an idea?
Thanks

 

[Gasman]

Set your checkbox on each record, then base the report where that field is set.
Will need to clear them all at some point, I would have thought?, on form load perhaps?

 

[Josef P.]

In a multi-user environment, I recommend using a temporary table (in the frontend or in a local DB file) so that no overlapping of the selection can happen.

 

[cheberdy]

Set your checkbox on each record, then base the report where that field is set.
Will need to clear them all at some point, I would have thought?, on form load perhaps?

how to check if the box has been ticked?

 

[cheberdy]

In a multi-user environment, I recommend using a temporary table (in the frontend or in a local DB file) so that no overlapping of the selection can happen.

Its always one user

 

[Gasman]

how to check if the box has been ticked?

It should be a Yes/no field, then just test if True.
If you are going to this for a lot of reports then a temp table would be better?

 

[Pat Hartman]

Its always one user

Is that ONE user for the whole application? One user at a time? or One user for this particular report?

If you EVER might have to deal with multiple users, just make that solution now so you won't have to change later. It is not more difficult. It just requires a separate table to log the ticks instead of leaving them in situ. In either case you have to remove the tics at the start of the next process. In one case you run an update query to update all rows with a true to a false. In the other case, you delete all rows for a specific user.

 

[CJ_London]

see this example

A multi select form using unbound check boxes

Thought I would put this up since it is a fairly common topic and I have put it up elsewhere - selecting records from a list for onward processing without the need for a table based tickbox. Similar in concept to the conditional formatting version I provided here...

www.access-programmers.co.uk