Required fields

[laura.dodge]

Hi, I'm working with a form that is for the data entry of a large
questionnaire. I have buttons at the end of each form that close the
current form and open the next form. I've set most of the fields to be
required, and I get the message that they are required when I try to
close the form without answering them. If I use the navigation buttons
before answering them however, they are not required. Is there some
way to require that these questions are answered before the navigation
buttons will take the user to the next form?

Thanks so much!

 

[Dorian]

It all depends on how your application is set up.
When going from form to form are you writing a table row? or just updating a
new set of data in the same row?
If the former, you just make the columns required in the table definition.
if the latter, you need attach code to the command button click event to
check each field has been set before allowing the next form to open.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[laura.dodge]

Thanks Dorian! Each form is attached to a different table. I had to
make many tables because the questionnaire is hundreds of questions
long. So I will end up with eight separate tables for each
participant's data, linked by the participant number. Would this be a
case of adding code to the command button click, and if so, can you
help me get started? I'm also trying to have the participant number
self-populate based on the previous table, to cut down on data entry
errors, but haven't had any luck so far...

Thanks again!