On change event of a field

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

Guest

Hallo

Is it possible to have a delay in a on change event?

What I am trying to do is I have a QTY field in a form and when a person
enters a QTY it should to a new field so what I do is on the on change event
I use the goto command and that works fine but I have the limit that I can
only enter on character in the QTY field so I would like a little delay of 1
or 2 seconds before it goes to the next field with to goto command is
something like this possible.

Regards
Markus
 
You don't need a delay, what you need to do is move the code from the Change
event to the After Update event.
 
That does not work as the after update event needs to be confirmed with enter
then only it will move to the field i want to

Markus
 
When do you want it to move?

Markus said:
That does not work as the after update event needs to be confirmed with enter
then only it will move to the field i want to

Markus
Click to expand...
 
On the On Change event I have the code DoCmd.GoToControl "SlotNo1" but this
command only allows me to type in one character then it goes to the
GotoControl but what I need it that there is a little delay of 1 to 2 seconds
before it runs the gotocontrole so its possible to enter 2 character as its a
QTY field.

Markus
 
Markus said:
On the On Change event I have the code DoCmd.GoToControl "SlotNo1"
but this command only allows me to type in one character then it goes
to the GotoControl but what I need it that there is a little delay of
1 to 2 seconds before it runs the gotocontrole so its possible to
enter 2 character as its a QTY field.
Click to expand...

Get rid of your code, apply a two digit InputMask and then turn on the AutoTab
property for the control. As soon as two digits are entered Access will
automatically "tab" to the next control.
 
Good solution, Rick.

Rick Brandt said:
Get rid of your code, apply a two digit InputMask and then turn on the AutoTab
property for the control. As soon as two digits are entered Access will
automatically "tab" to the next control.
Click to expand...
 
Back
Top