CheckBoxes in Continous Forms

[abouddan]

Hi all
I am trying to create a form 'Form1' that updates my database. Fist this form is based on a query that returns all the records in table 'employe'.
query1="Select id, name, salary from emoloyee"
Form1 is Continous and it shows me all the records and within every record I have a check box. In the form footer I have a button that increase salary of all the selected rows.

The problem is that when I check one check box, all check boxes will be checked. And that is normal cause all the check boxes have the same name.
What can I do :
First to check the rows I want
Second to update the selected rows.


Many thanks

[Rabbit]

You can have an extra column in the table that's the checkbox.

The you can use an update SQL to update the salary and switch the checkbox back to unchecked.

[abouddan]

I don't need An extra field in my table All my need of checkboxes is in that form nowhere else. The objective of the checkbox is not storing data it's just to do a paritcular job to some records, and another time do another job to others.

So the checkboxes must be related to this form only.

[Rabbit]

I don't need An extra field in my table All my need of checkboxes is in that form nowhere else. The objective of the checkbox is not storing data it's just to do a paritcular job to some records, and another time do another job to others.

So the checkboxes must be related to this form only.

There's a problem with doing that in a continuous form. And you brought up that problem yourself. Unbound checkboxes will check for every record in a continuous form. Either you do it one record at a time or you implement the checkbox in your table so that you can do record level checks.