A
Andy
Good morning all!
I have a DB set up to help organize and create
questionnaires.
One of the functions is that the DB stores standard
response sets in a "response" table, that can then be
called in the main form. For example, the "satisfied"
response set calls the answer set "1. Totally Satisfied"
to "5. Not at all Satisfied." The user can then edit the
answer choices for that response set, if needed.
Now, that part of the form and table work beautifully.
But then we have some items that use no standard response
set (mostly items with a blank to fill in). My initial
solution was to create a row in the table titled "no
response" and to make this the default value for
the "response" field in the form.
I have some users who tend to fill in the responses
for "no response" before telling the form that they want
a new response set. Then, the "no response" item has
data in it (where it should have none). Subsequent
records, when opened in the form, will then default to
having an answer set when they should default to being
blank.
It seems like the best solution would be to lock the "no
response" row in the records table, so that the form
users cannot edit that particular row, but can edit other
rows in the table. Can any of you teach me a way to do
this?
-Andy
I have a DB set up to help organize and create
questionnaires.
One of the functions is that the DB stores standard
response sets in a "response" table, that can then be
called in the main form. For example, the "satisfied"
response set calls the answer set "1. Totally Satisfied"
to "5. Not at all Satisfied." The user can then edit the
answer choices for that response set, if needed.
Now, that part of the form and table work beautifully.
But then we have some items that use no standard response
set (mostly items with a blank to fill in). My initial
solution was to create a row in the table titled "no
response" and to make this the default value for
the "response" field in the form.
I have some users who tend to fill in the responses
for "no response" before telling the form that they want
a new response set. Then, the "no response" item has
data in it (where it should have none). Subsequent
records, when opened in the form, will then default to
having an answer set when they should default to being
blank.
It seems like the best solution would be to lock the "no
response" row in the records table, so that the form
users cannot edit that particular row, but can edit other
rows in the table. Can any of you teach me a way to do
this?
-Andy