userform question

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

have 2 fields on a user form. when textbox1 is exited, it looks up the value
and stores it in a variable. if i don't find it, i pop a message box but i'm
having a problem setting the focus back to textbox1. it always goes to
textbox2 even thought i set focus back to textbox1.

what's the best way to only go to textbox 2 if it finds the value entered
into textbox1, otherwise clear textbox1 and set the focus.

unloading and loading the form works, but just looking for a better way.
 
i just added
if me.textbox1.value = "" then me.textbox1.setfocus

into a textbox2_enter procedure and it seems to work.

any better ideas?
 
Back
Top