Unbound checkbox on datasheet subform - check one and they all check

[Robert]

Is there any way to check just the one you checked?

Robert

 

[Jeanette Cunningham]

Hi Robert,
this issue was discussed at length recently on this newsgroup.
The short answer is No.
The long answer is that you can make the checkbox bound, but it is not very
easy.
Look at this thread:
checkbox on continuous form
from Design by Sue
Thursday 20 December 2007

Jeanette Cunningham

 

[Albert D. Kallal]

Is there any way to check just the one you checked?

Robert

If you bind the check box value to a function, the you can do this. It is
far easier to simply add a new column. However, if you want to see a example
of a check box un-bound to an underlying field, you can find the
"multislect" example of mine here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Robert]

Thanks.

Hi Robert,
this issue was discussed at length recently on this newsgroup.
The short answer is No.
The long answer is that you can make the checkbox bound, but it is not
very easy.
Look at this thread:
checkbox on continuous form
from Design by Sue
Thursday 20 December 2007

Jeanette Cunningham

 

[Robert]

Thanks.

If you bind the check box value to a function, the you can do this. It is
far easier to simply add a new column. However, if you want to see a
example of a check box un-bound to an underlying field, you can find the
"multislect" example of mine here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Linq Adams via AccessMonster.com]

That's a nice hack, Albert, but to keep the OP from spending hours trying to
get it to work on his Datasheet form, he should be made aware that the form
in your example is not in Datasheet View, but rather in Continuous View, made
to look like Datasheet View! You can go into Design View and place uncound
controls on forms in Datasheet View, but they won't show up when the form is
run, much less function.

BTW, I've got your site bookmarked, and pass it on when someone has a problem
that one of your hacks can solve! Keep up the good work!

Linq

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Robert]

Albert, I put in a post in the reports group which refers to your WordMerge
database. I'm wondering how you customized the toolbar in that report.