checkbox on a continuous form..

W

Warrio

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
 
A

Allen Browne

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.
 
Top