Selecting multiple records from a form

[arm1]

I was wondering if anyone knows:

Let's say I have a form (or subform) that displays a bunch of records, in tabular form.

Is there a way I can add a checkbox (or some other indicating control) that would allow the user to select any number of records.

The application of this is simple:

I have a number entered by the user. I have a form/subform displaying all the records, and I need the user to select (check off) the ones he is referring to.

Then I will need to go through the values of this control, see which record(s) the user had checked off... and change one of the field values in each.

Thank you for any help you can provide,

- arm1

 

[ajetrumpet]

if this is a continuous form, you can use the recordsetclose property of the form or subform to loop through and check to see which records can be identified by the checkmarks, and then update appropriately.

 

[scooteman]

Add a field to your table and set it to Yes/NO property This will give you a check box field you can put in forms.

 

[arm1]

I always forget the exact definition of a continuous form, but I believe it IS.

I am able to add a checkbox from the tools... the problem is that when I put it in the details section of my form (so that it applies to each record), it is binary (on / off)... so checking it for one record checks it for all the records.

I was hoping there was a way to break the link between all the chechboxes, so that they would be acting independent of each other, and dependent only 1-to-1 for the record... allowing me to see which one(s) were selected, and which ones were not.

The other solution of adding a field to the table is one I thought of. It will certainly be my last resort if I can't find another solution. The problem with it is... if I use the field as a record selector, then I will REALLY have to carefully manage its use. There are a bunch of users using this, and if I apply actions in several areas upon selection, but many people can select many records for many different reasons... I will have to ensure the actions are applied properly, to ONLY the applicable records, which may be easier said than done!

Thanks for all your help,

- arm1