S
Steve in MN
I used the Dhookum survey db as a model to start the program and have the
entry form working to a point.
I only have one survey in the db and when the control number is entered in
the main form, i have it run a append query to pull some supporting details
from another table into the mainform table. Then it appends the 11 questions
into the subform table. All of the responses are either "Yes", "No" or "N/A"
and the default values are set to null so the keyer can tell what is done.
In addition to this each question is weighted with a "Yes" having 2 or 3
point value and a No having no point value. I have functions stamping the
value for each question into another field in the subform as it passes thru
the answer text box (on Got focus and on change).
The problem i am having is that the validation rule to prevent having a null
value doesn't stop the record from being saved is any of the questions are
null. Once the answer is populated and then try to erase and leave null,
then it prompts with the rule.
If i set the default value in the table to populate as "Yes", then my coding
doesn't work append the value for the question.
Any suggestions?
entry form working to a point.
I only have one survey in the db and when the control number is entered in
the main form, i have it run a append query to pull some supporting details
from another table into the mainform table. Then it appends the 11 questions
into the subform table. All of the responses are either "Yes", "No" or "N/A"
and the default values are set to null so the keyer can tell what is done.
In addition to this each question is weighted with a "Yes" having 2 or 3
point value and a No having no point value. I have functions stamping the
value for each question into another field in the subform as it passes thru
the answer text box (on Got focus and on change).
The problem i am having is that the validation rule to prevent having a null
value doesn't stop the record from being saved is any of the questions are
null. Once the answer is populated and then try to erase and leave null,
then it prompts with the rule.
If i set the default value in the table to populate as "Yes", then my coding
doesn't work append the value for the question.
Any suggestions?