Checkbox

[accessisnew]

Have a form that lists rows from a table; one row per form. Set form to continuous so multiple rows appears on a page. Put a check box to left of data from table to allow user to pick rows from the list to process/not process in the next step.

Problem: when I click any one of the check boxes, all the check boxes either check or uncheck. I want each to act as a separate control.

How do I do that?

 

[Eupher]

If the checkbox is not bound to a field in the table/query, this is normal behavior for continuous forms.

Ken S.

 

[accessisnew]

So, I tried radio, toggle, and command buttons with the same result. I guess I'll need to just create a text box and control it programmatically.

 

[PHV]

accessisnew, in the Detail section of a continuous bound form, ANY UNBOUND control has a SINGLE instance for ALL rows.
Either use a MultiSelect ListBox or add a Boolean (YesNo) field to the underlaying table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

You will have the same problem with a text box as well. What I do if I want this affect is to put a "dummy" boolean field in my table. I use it to hold the checks until I write them to another table in the on current event. Then I use the on current event to read from the other table and populate the checks.
Depending on what you are trying to do, you may be able to accomplish your results using conditional formatting.