By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

CheckBoxes in Continous Forms

abouddan
P: 42
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
Apr 30 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,324
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.
Apr 30 '07 #2

abouddan
P: 42
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.
May 1 '07 #3

Rabbit
Expert Mod 10K+
P: 12,324
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.
May 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.