Auto Enter when typing in form

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

Hope this is easy. I have a form that you enter your
initials into a field and then click OK to open another
form. I have an input mask of "aa" so that you can't
enter anymore than 2 letters in that field. How can I
make it so that when you type the 2 letters it will
automatically continue on to another form(which is what
the OK button did) without clicking OK?
Thanks for any help you can give.
 
Shane,

If the button is doing exactly what you want then you can
copy the code behind the button and then paste it into the
AfterUpdate event of your entry box. Make sure that you
don't copy the Sub.... or End Sub lines as your AfterUpdate
will have it's own.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top