Checkboxes in a form

[jbs]

Hi,

I have a form with checkboxes. I have data linked from a table in the data section under the form. What I need is a way that will only check the check box for each name that is selected and not the entire column of check boxes.

Thanks.

 

[boblarson]

Hi,

I have a form with checkboxes. I have data linked from a table in the data section under the form. What I need is a way that will only check the check box for each name that is selected and not the entire column of check boxes.

Thanks.

For data sheet or continuous view you would need to use a bound control. An unbound control won't work in that situation.

 

[jbs]

Thanks for the reply, please excuse my amatuerness

I have 2 text boxes, one for name and one for date. When I select a persons name the date relating to the name is entered into the second text box and then i would click the checkbox when the person meets the set criterea.

Would an unbound checkbox work for this scenario to solely update each persons name and not the entire column of checkboxes in that data part of the form?

 

[boblarson]

Would an unbound checkbox work for this scenario to solely update each persons name and not the entire column of checkboxes in that data part of the form?

No, it would not. In a datasheet view or continuous form view the control you see is a single control but Access makes it look like more than one but it really isn't. And so an unbound control on a datasheet view form or continuous view form, when you click it, is going to check all of them. So if you don't want it to act like that you'll need a field in your table to store the checked value OR you will need to use the form in SINGLE VIEW only.

 

[jbs]

Thanks for the reply

Basically what im after is for each person to have their own indiviual checkboxs in order to have an email generated based on what is checked. I have that code and I am able to generate the email but I am stuck on actually keeping that data logged for historical purposes for each individual person.

One possible way i have is to have a table with the same fields and then check them and then have the form as solely an email generater, but i would like a more efficient way of only checking the boxes once on the form and then logging that infomation

Do you have a suggestion for a possible work around?