Hello
Is it possible to have a checkbox on a continuous form that behaves
separately on each row without bounding the it to a field?
I cannot have it bound even to a temporary table because many users will
work on it at the same time, so if one user
checks a text box, it shouldn't get checked for all other users.
is there any solution?
Thanks for any suggestion
Allen Browne - 31 Mar 2005 16:04 GMT
No. An unbound control has only one value for the entire form, so cannot
have different values on different rows.
Assuming you have a split database, you could create a table in the front
end and store the primary key values of the records the user selects. The
RecordSource of the form would then be a query that contains the original
(shared) table, with an outer join to the local user's table. In the query,
you could create a calculated field:
IsChecked: ([MyLocalTable].[MyPK] Is Not Null)
Then you could represent it with a checkbox in your form, and overlay it
with another unbound control that does nothing except respond to its Click
event to Execute an Append or Delete query to add/remove the record from the
local table.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> Hello
>
[quoted text clipped - 8 lines]
>
> Thanks for any suggestion
Jeff Conrad - 31 Mar 2005 17:45 GMT
I believe MVP Albert Kallal has something you may be interested in.
Go to his site here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
Look for the download file called "Multi Select Example."

Signature
Jeff Conrad
Access Junkie
Bend, Oregon
> Hello
>
[quoted text clipped - 8 lines]
>
> Thanks for any suggestion
Warrio - 31 Mar 2005 18:36 GMT
I'll look at that! that's cool
thanks again for your help!!!
> Hello
>
[quoted text clipped - 8 lines]
>
> Thanks for any suggestion
Jeff Conrad - 31 Mar 2005 19:15 GMT
> I'll look at that! that's cool
> thanks again for your help!!!
You're welcome, good luck with your project.

Signature
Jeff Conrad
Access Junkie
Bend, Oregon