I am trying to use check boxes as a yes/no answer about whether members have completed training modules, and bind them to a table.

I get this error when tick the boxes, and try to close the form; "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)"

When I reopen the form the check boxes are greyed out until i tick them (not getting values from table) :confused:

Any help appreciated :confused: :)

Matthew

Hi Matthew,

Create a yes/no field in the table an bind the checkbox to this field.

Edo