Updatable checklist

[JCricket]

Hi, I am trying to make a checklist database, where the form displays the
list of procedures with checkboxes, based on an underlying table. However,
from time to time the procedures change, so I was wondering if there was some
way to design the database where you can either add or delete a step in the
checklist without having to manually edit the table and the form - I'm not
confident in the manager's ability to successfully edit the form/table
without wreaking havok, so ideally I want to make a button he can click, type
in the name of the new step, and have it insert the new line in the checklist
and field in the form.

 

[Duane Hookom]

You should not be storing the procedures in field names. Each checkbox value
should create a new record in a table. This is quite a bit like the At Your
Survey demo available at
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4&SID=ea383e484z3ac469fd5bz4z9fe39642d.
There is a similar employee evaluation sample at the same link.