Validating Data Entry thru a form

[shriil]

Hi

I have this Data Entry Form which consists of a Name Field and a
Logical Yes/No Field for the Data Entry Operator to fill in. The Name
gets stored in a Table if and only if the 'Yes/No' field is made 'Yes'
by the Data Entry Operator. At present, on closing of the form, the
names get stored in the table depending on whether the operator has
marked the Yes/No field as Yes. (The default value for this field is
'No'). To make this more easier for the Data Entry Operator, I would
like help from you guys on how to go about doing the following actions
as detailed below:

The moment the user tries to close the form, a query will run on the
data already entered by the user, to search for any record where the
'Yes/No' field has not been made 'Yes'.
Accordingly if the query returns zero records, a pop up message will
inform the operator that " Data entry Successful' and subsequently will
close the form.
If the query returns any record, the pop up message will indicate that
"Some records have their Yes/No field unchanged at 'No' " and
accordingly will display those respective records. The closing of the
form will remain inhibited unless and untill the operator corrects
those particular records.

Thanks for the help in advance

 

[Douglas J. Steele]

Assuming that you're talking about a bound field, the data is stored as soon
as the user moves from one record to another, so the concept of only saving
some of the records isn't possible.

 

[shriil]

Yes that's right. The Data-entry Form populates a table which has the
Name field and the 'Yes/No' field. As per the existing mode of
data entry, the table may have some records where the 'Yes/No'
field remains selected as 'No' owing to overlooking on part of the
Data-entry person. Now I then have a final Make-Table query which has a
criteria to select those records from the original table whose
'Yes/No' field is set as 'Yes'. From here, the problem starts,
as the records with 'No' in the 'Yes/No' field, is absent in
the final table. That is why I feel that the Data entry form needs
those modifications such that the 'Yes/No' field is not
inadvertently missed out during data entry.

You can say that I can always set the default value of 'Yes/No'
field as 'Yes', which would then eliminate the problem. I have
deliberately kept the default value as 'No' for forcing the Data
entry operator to make it 'Yes' when he enters the name in the
'Name' field... Just to make him aware of the seriousness and the
reliability of the data which he is entering.

For this reason, if I can ensure that the Operator will have to ensure
that all the 'Yes/No' fields have been properly selected before
closing the 'Data Entry form', (please refer to my initial post),
my mission will be accomplished.

Hope that I have been able to explain the reason for my modification.

 

[shriil]

Yes that's right. The Data-entry Form populates a table which has the
Name field and the 'Yes/No' field. As per the existing mode of
data entry, the table may have some records where the 'Yes/No'
field remains selected as 'No' owing to overlooking on part of the
Data-entry person. Now I then have a final Make-Table query which has a
criteria to select those records from the original table whose
'Yes/No' field is set as 'Yes'. From here, the problem starts,
as the records with 'No' in the 'Yes/No' field, is absent in
the final table. That is why I feel that the Data entry form needs
those modifications such that the 'Yes/No' field is not
inadvertently missed out during data entry.

You can say that I can always set the default value of 'Yes/No'
field as 'Yes', which would then eliminate the problem. I have
deliberately kept the default value as 'No' for forcing the Data
entry operator to make it 'Yes' when he enters the name in the
'Name' field... Just to make him aware of the seriousness and the
reliability of the data which he is entering.

For this reason, if I can ensure that the Operator will have to ensure
that all the 'Yes/No' fields have been properly selected before
closing the 'Data Entry form', (please refer to my initial post),
my mission will be accomplished.

Hope that I have been able to explain the reason for my modification.