OnExit action from field...

  • Thread starter Thread starter James Newman
  • Start date Start date
J

James Newman

Hey all,

I hope this is a simple one.

I have a subform where I am filling in 4 fields. If the third field
is a certain value I wish to fill in the fourth field. If not I would
like to skip the fourth field and jump to the next record in the
subform.

Is this possible? I am assuming there needs to be code associated
with the OnExit property of the third field.

Of course any help is greatly appreciated!


Thanks,

James Newman
 
James Newman said:
Hey all,

I hope this is a simple one.

I have a subform where I am filling in 4 fields. If the third field
is a certain value I wish to fill in the fourth field. If not I would
like to skip the fourth field and jump to the next record in the
subform.

Is this possible? I am assuming there needs to be code associated
with the OnExit property of the third field.

Of course any help is greatly appreciated!


Thanks,

James Newman
Click to expand...

Actually, it's not as simple as you might think, not for any technical
reasons, but because you need to really think through the implications of
what you are asking.

What if your user is leaving the 3rd field, not because they have finished,
but because they wish to go back to the 2nd field to correct an error? Do
you still want to "jump to the next record"?

What if the user is not entering a new record, but is amending an existing
one? Suppose there is already a value in the 4th field, but your user then
amends the 3rd field to a value that doesn't qualify for a value in the 4th
field? What do you then want to happen to the 4th field?

A little thought would soon throw up a few more what-if's like this. It's
generally a mistake to attempt to force navigation in Access into tight
straightjackets like this: there are so many scenarios as to what the user
might be doing, and you will need to think of, and deal with, all of them!
 
Back
Top