Multiple Labels Form Question

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

Guest

This is probably a really dumb question but I seem to have hit a wall and
cannot for the life of me figure it out (or how to phrase properly to search
for help). Anyhoo here goes...

Using code created by Roger Carlson, I created a form to choose multiple
part numbers to create labels. Form works this way:

Upon entering form, user chooses first P/N from list box, hits enter which
goes to how many labels box, hits enter which then tabs to Command Button to
"Add Label" (at which time it adds the label) then the user has to click on
the list box again to enter the next P/N and so on. My users are complaining
that this is a pain in the you know what and that they would prefer if after
the label is added the cursor would automatically go back to the Choose P/N
list box. I'm quite sure that this can be done but don't know the code for
it.

Can anyone help me with this? Any help/code would be greatly appreciated.

Thanks Kindly
 
Dear "Kindly"

:-)

In the ON CLICK event for the Command Button,
after the existing code for the event,
add the following line

Me![WhateverIsYourFirstPartNumberListBoxName].setfocus

HTH
 
Works like a charm DavidG. Thank you so much.



DavidG said:
Dear "Kindly"

:-)

In the ON CLICK event for the Command Button,
after the existing code for the event,
add the following line

Me![WhateverIsYourFirstPartNumberListBoxName].setfocus

HTH

Using code created by Roger Carlson, I created a form to choose multiple
part numbers to create labels. Form works this way:

Upon entering form, user chooses first P/N from list box, hits enter which
goes to how many labels box, hits enter which then tabs to Command Button
to
"Add Label" (at which time it adds the label) then the user has to click
on
the list box again to enter the next P/N and so on. My users are
complaining
that this is a pain in the you know what and that they would prefer if
after
the label is added the cursor would automatically go back to the Choose
P/N
list box.
Click to expand...
Thanks Kindly
Click to expand...
Click to expand...
 
Back
Top