Data entry on Form with Tab Control

[Judy]

I'm also posting this in the VBA forum, so please don't waste your time reading it twice!

I have a form to enter employee information using a Tab Control with two tabs. The first tab includes the employee's personal information, the second tab includes the employee's work location information. The tab index property of the Tab Control is set to 0. Problem is, when all of data is entered into the fields on the first tab, a new blank form appears (it moves to the next record). Is there a way to make the cursor move to the next field on the second tab so that data is entered before going to the next record?

I've tried DoCmd.GoToPage on the form's Before Update event, but, unless I'm using the wrong syntax, it won't work!

Any suggestions??

Thanks!

Judy

[This message has been edited by Judy (edited 08-03-2001).]

 

[rschultz]

can you set the tab order so it will go to a textbox on teh next tab? OR you can try putting txtNextTextBox.SetFocus (where txtNextTextBox is the textbox you want the focus to go to on the second tab) in the OnClick event (or somewhere) of the last textbox of the first tab.

 

[Judy]

The tab order doesn't work because it sets the tab order for each page separately, not the control, but setting the on lost focus event of the last control on the first page to the first field on the second page worked great! Thanks for the help!