If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Questions check boxes from new Access user
I have just created my first Access database and form. I have a problem with
the check boxes. When I am in record #1 and check the applicable box, it stays checked in all the other records. So when I change the check box to the applicable one for record 2, that becomes checked in all records. How do I format my checkboxes (I have 10 of them) so that checking them in record 1 only checks them in record 1, instead of checking them in all of the records? I have 10 check boxes, and in some records, as many as 8 of them need to be checked; in some records, only 1 needs to be checked. Is there a better way to do this other than check boxes? |
#2
|
|||
|
|||
Questions check boxes from new Access user
"Flashjw" wrote in message
... I have just created my first Access database and form. I have a problem with the check boxes. When I am in record #1 and check the applicable box, it stays checked in all the other records. So when I change the check box to the applicable one for record 2, that becomes checked in all records. How do I format my checkboxes (I have 10 of them) so that checking them in record 1 only checks them in record 1, instead of checking them in all of the records? I have 10 check boxes, and in some records, as many as 8 of them need to be checked; in some records, only 1 needs to be checked. Is there a better way to do this other than check boxes? From the sound of it, your check boxes aren't bound to any field in the table. If you want to store the state of a check box for a particular record, you must have a Yes/No field in the form's underlying table (the form's RecordSource) to hold that state, and you must bind your check box to it by setting the check box control's Control Source property to the name of that field. Any control that is unbound -- that is, with a blank Control Source -- will have the same value for all records on your form. It's the ControlSource that binds the control to a particular field in the form's current record. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
Questions check boxes from new Access user
Flash,
This would imply that the checkboxes are *unbound*, i.e. if you look at their Record Source property it will be blank. Is that what you intend, or are these checkboxes meant to be linked to fields in the form's underlying table? Having said that, 10 Yes/No fields like this means it is also likely that your table design could be improved. Someone will be able to advise on this aspect if you can give more details of the data you are working with, and the meaning of the checkboxes. -- Steve Schapel, Microsoft Access MVP Flashjw wrote: I have just created my first Access database and form. I have a problem with the check boxes. When I am in record #1 and check the applicable box, it stays checked in all the other records. So when I change the check box to the applicable one for record 2, that becomes checked in all records. How do I format my checkboxes (I have 10 of them) so that checking them in record 1 only checks them in record 1, instead of checking them in all of the records? I have 10 check boxes, and in some records, as many as 8 of them need to be checked; in some records, only 1 needs to be checked. Is there a better way to do this other than check boxes? |
#4
|
|||
|
|||
Questions check boxes from new Access user
I have tried to do that but I guess I'm doing something wrong, because now I
can't even check the boxes - they are grayed out on the form and won't check. Can you give me step by step instructions? I'm not altogether sure I successfully created a Yes/No field (I think I did) and I am more sure that the problem is that I did not bind the check box to the field correctly. Any step by step help would be greatly appreciated! Thank you so much! "Dirk Goldgar" wrote: "Flashjw" wrote in message ... I have just created my first Access database and form. I have a problem with the check boxes. When I am in record #1 and check the applicable box, it stays checked in all the other records. So when I change the check box to the applicable one for record 2, that becomes checked in all records. How do I format my checkboxes (I have 10 of them) so that checking them in record 1 only checks them in record 1, instead of checking them in all of the records? I have 10 check boxes, and in some records, as many as 8 of them need to be checked; in some records, only 1 needs to be checked. Is there a better way to do this other than check boxes? From the sound of it, your check boxes aren't bound to any field in the table. If you want to store the state of a check box for a particular record, you must have a Yes/No field in the form's underlying table (the form's RecordSource) to hold that state, and you must bind your check box to it by setting the check box control's Control Source property to the name of that field. Any control that is unbound -- that is, with a blank Control Source -- will have the same value for all records on your form. It's the ControlSource that binds the control to a particular field in the form's current record. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#5
|
|||
|
|||
Questions check boxes from new Access user
"Flashjw" wrote in message
... I have tried to do that but I guess I'm doing something wrong, because now I can't even check the boxes - they are grayed out on the form and won't check. Can you give me step by step instructions? I'm not altogether sure I successfully created a Yes/No field (I think I did) and I am more sure that the problem is that I did not bind the check box to the field correctly. Any step by step help would be greatly appreciated! Thank you so much! Please post the RecordSource property of the form and the ControlSource property of each of the check boxes. The properties are listed (with a space between "Record" or "Control" and "Source") on the Data tab of the form or control's property sheet in design view. If the Recordsource is the name of a table, please briefly list the names and data types of the fields in that table. If it's a query, whether the name of a stored query or an inline SELECT statement, please post the SQL of that query. I'm going out now and probably won't be able to reply until sometime tomorrow. It may well be that someone else will be able to use the info you post to solve your problem before then. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|