chkbox and continueos form

[alaric]

is there a way to check what record is selected (ie chkbox) on a cont.form

I have many detailrecords here and I want to give the user the possiblity to check certain records for printing. (thr cont. form is based on a query)
I tried to update an extra colomn in this table (with vba code). But this gives errors (because of multiple users (the form and the code) and the same record..)

Im stucked
Does anyone have a suggestion or a better idea? maybe Im thinking the wrong way for a solution?

thx
Al

 

[Pat Hartman]

You can make a table to hold the selected items. If the app is split into fe and be and the fe is stored locally on each user's PC, the table should be in the fe so that each user has a separate copy. If users share a copy of the fe or the db is not split, the table needs to include userID as well as the ID of the selected record. That way, selections be each user can be kept separate.

Add a button to the form and in the button's click event, add the selected ID to the report table. Then change the RecordSource of the report so that its query joins to the selected ID's table.

 

[alaric]

Good Suggestion!!!!

Simplicity is beautifull.

this is helpfull. Im going to build it right away.

thx

Al