M
Maija
I have two questions dealing with moving automatically to
the next control on a form after data entry is complete in
the first control.
Currently, I am using the "On Change" event to move
automatically to the next control for controls that
require a single character for entry. For example,
entering "O", "T", "F", or "C" in the LOCMODE control will
move the user to the next control automatically, without
pressing enter or tab.
However, this does not work for a few of my controls. When
I put the macros for these non-working controls on the "On
Change" event, they behave like they were put on "After
Update". The issue appears to be that the macros for these
non-working controls are conditional: if the control=A-E,
it should move to the next record like the working
controls; but if the control=F, it makes the "Other"
control visible and moves to it. Why aren't these controls
working like controls without conditional macros?
The second question is how to make "On Change" work for
controls that require 2 characters of entry, like codes
numbered 01 through 15 (for the CATCODE control). There
may be a way to do this that does not use "On Change", but
I don't know it. People have recommended using the input
mask with "On Change", but this creates an error as "On
Change" continues to activate after the first character is
entered.
Thanks so much for any help!
Maija
the next control on a form after data entry is complete in
the first control.
Currently, I am using the "On Change" event to move
automatically to the next control for controls that
require a single character for entry. For example,
entering "O", "T", "F", or "C" in the LOCMODE control will
move the user to the next control automatically, without
pressing enter or tab.
However, this does not work for a few of my controls. When
I put the macros for these non-working controls on the "On
Change" event, they behave like they were put on "After
Update". The issue appears to be that the macros for these
non-working controls are conditional: if the control=A-E,
it should move to the next record like the working
controls; but if the control=F, it makes the "Other"
control visible and moves to it. Why aren't these controls
working like controls without conditional macros?
The second question is how to make "On Change" work for
controls that require 2 characters of entry, like codes
numbered 01 through 15 (for the CATCODE control). There
may be a way to do this that does not use "On Change", but
I don't know it. People have recommended using the input
mask with "On Change", but this creates an error as "On
Change" continues to activate after the first character is
entered.
Thanks so much for any help!
Maija