userform question

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.
 
G

Gary Keramidas

i just added
if me.textbox1.value = "" then me.textbox1.setfocus

into a textbox2_enter procedure and it seems to work.

any better ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top