Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

MS Access tab order first in the header

Avatar of jaud
jaud asked on
Microsoft Access
7 Comments1 Solution1087 ViewsLast Modified:
Hello,
I need some help getting the tab order of my access forms to work the way that is needed.

I have a search form (newsearchfom) which has unbound text boxes in the header.  
When the form is loaded I need the tab order to start on the last name box (last1name)in the header (see picture)  I put  LAST1NAME.SETFOCUS in the on event field on the form, but it takes 2 pushes of the tab button for the curser to arrive at the field.  The curser doesn't not seem to be any place else before or after pushing the tab button or after pushing the tab button once.

I tried adding an unbound text box in the detail section , making in invisable and setting the tab order to start with it, and then setting the on click event to LAST1NAME.SETFOCUS but that did not work.  I tried setting the on load and on open events of the form to LAST1NAME.SETFOCUS but they did not work either (they either did not work at all or were no faster than two tab pushes)
Is there a way to set the focus to the last name field in the header when the form is loaded to be able to enter text immediately?

Thanks.
record-search.JPG
ASKER CERTIFIED SOLUTION
Avatar of reb73
reb73Flag of Ireland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers