Controlling data Entry on Forms

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hi All,

I want to control data entry on on a form for other users.
If they check a box then they must complete other fields
and the click would control what field are required data
entry and where the next tab or enter stop would be and
rather the user could exit/save the record without
completing.

The form identifies various problem(s) with an invoice to
be processed. It allows the user to define the problem(s)
with a check box selection, (items not rec'd, wrong prices
charged, etc)then give more detail that would aid in
resolution. After the problem is resolved, there are
check boxes to select the root cause of the problem and a
date resolved. There is also a "date completed" that will
identify that all probelms are resolved with that invoice,
there could be multiple selections with one invoice.

The purpose of the form is to track problems, and identify
where processes need improvement.

For example: If a check box is selected, then goto
specified field(s) related to that selection, type in data
required.

If a check box is not selected, then data entry is not
required in specified fields, and the tab or enter keys
skip the related specified fields, and they do not require
data entry.

Additionally: If a "date completed" field is entered, then
there are check boxes and a date that would be required,
to specify resolution of an individual problem, and then
lock that record.

I have looked at the help for expession builder but do not
understand how it could work in this manner. Any
suggestions would be greatly appreciated!

Thank you,
Linda
(e-mail address removed)
 
Linda,

There is no expression that will do what you want.

You are either going to have to write some code that enables and disables
code according to what check boxes are selected or use popup forms fro each
problem. because you wish to lock the record after completion I would
suggest making the form readonly and using buttons to open popup forms.
check for completion date in the code that opens the forms and only open the
forms if the date field is null.

To check for completed fields use the before update event on the form and
write code to check the required fields and warn the user that data is
missing.
 
Back
Top