Check Boxes in Data Access Page

[Boozehound]

Hi,

I've created a data access page for staff to verify their permissions on one of our systems.

A section of the page has a list of permissions and whether it is currently available to them (Y) or not (N). The Y and N values are lifted directly from a database table.

I have added check boxes next to each of these entries and asked the user to check it if the current value is correct. However, when I check a box, save the page and close it, when I re-open the page the check box has defaulted back to unchecked. Is it possible for the check to be saved?

Thanks!

[NeoPa]

It is.

I don't know much about your setup but the control needs to be bound to the underlying record source.

NB. A CheckBox is fundamentally a boolean (Yes/No; True/False) control. It can be set to allow Nulls (unset), but cannot contain or save the string values "Y" & "N".