First field required but what if user needs to go back to last for

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure out how to resolve this. The first field of a form is required
via Exit Event. The same field is set for focus OnCurrent of the form and I
don't want to change that necessarily. The problem as I invision it is....if
the data entry user just finishes up the last record and starts the new
record but suddenly realizes they need to go back to the last record for some
reason or maybe they weren't even done and tabbed to the new record in error,
because the first field is required they are now stuck with the OnExit error
msg box. Any ideas? All I can think of is to make a generic useless control
which will get focus first and look bad.

Thanks, Kristine
 
smilee8_28 said:
I can't figure out how to resolve this. The first field of a form is
required via Exit Event. The same field is set for focus OnCurrent of
the form and I don't want to change that necessarily. The problem as
I invision it is....if the data entry user just finishes up the last
record and starts the new record but suddenly realizes they need to
go back to the last record for some reason or maybe they weren't even
done and tabbed to the new record in error, because the first field
is required they are now stuck with the OnExit error msg box. Any
ideas? All I can think of is to make a generic useless control which
will get focus first and look bad.

Thanks, Kristine
Click to expand...

Exit is a bad event to enforce data validation for the reason you just saw. In
addition it enforces nothing if the user never enters that control in the first
place. It would be better to just make that a required field in the table's
design. Then the system won't care about entering the control and leaving it
empty, but it will not allow the record to be saved unless it is filled in.
 
Back
Top