Form with several Yes/No Fields

[Guest]

I have designed a form that is used to help me in my Human Resouce duties.
As a person is hired, the person has several forms that need to be signed and
kept on file. I have about 12 forms that are used and decided a yes/no field
for each turned in form would help me track the information. After I do the
yes/no fields with a check, and go to the next person's form, the previous
person's information disappears. It is kept in the table, but doesn't stay
on the form. It is as if I did not enter any information...the form is
entirely blank.

What am I doing that is wrong.

Thanks

 

[Rick B]

Are your checkboxes bound fields? What is the record source for the fields?
If they are bound to Yes/No fields in your table, then they should show the
value from the table for the currently displayed record.

Rick B

 

[Guest]

The fields are bound. What do you mean by a record source. I have a table
that has a yes/no field for each category.

The information just will not save.

 

[John Vinson]

I have designed a form that is used to help me in my Human Resouce duties.
As a person is hired, the person has several forms that need to be signed and
kept on file. I have about 12 forms that are used and decided a yes/no field
for each turned in form would help me track the information. After I do the
yes/no fields with a check, and go to the next person's form, the previous
person's information disappears. It is kept in the table, but doesn't stay
on the form. It is as if I did not enter any information...the form is
entirely blank.

What's the Recordsource for the Form? Are these checkboxes bound to
table fields?

A better design, in my opinion, would be to recognize that you have a
Many (employees) to Many (forms) relationship. A good design for this
would be to have three tables: your existing Employees table; a table
of Forms (with twelve rows today, maybe fourteen or nine next week);
and a table of Signatures, with fields for EmployeeID and FormNumber
and perhaps for DateSigned. Each form signed by an employee would
create a new record in this table.


John W. Vinson[MVP]