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

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

Robert

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" wrote in message
...
Is there any way to check just the one you checked?

Robert

"Robert" wrote in message
...
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 he

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

Thanks.
"Jeanette Cunningham" wrote in message
...
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" wrote in message
...
Is there any way to check just the one you checked?

Robert

Thanks.
"Albert D. Kallal" wrote in message
...
"Robert" wrote in message
...
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 he

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

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
http://www.accessmonster.com/Uwe/For...forms/200712/1

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.

"Albert D. Kallal" wrote in message
...
"Robert" wrote in message
...
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 he

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada