Tab Stop to new record

[RustyRick]

On my form my Tab stops at a "New Record" button. After the "Enter key" can I make the cursor go to the first field in the form?

 

[John Big Booty]

An easy way would be to put the following code in the Form's On Current event;

Me.NameFirstControl.SetFocus

 

[RustyRick]

Thank you so much. This form seems so impersonal to just say thanks to someone you cant shake hands with. :-(

Thank a ton!!!!

 

[John Big Booty]

There a couple of thing you can do to show your appreciation for the assistance you have received. The first you have already done i.e. clicking the Thanks Button , the other is to click the reputation icon;

 

[RustyRick]

While we're chatting. How can I force my form to open in a "New Record" window instead of the first record in the Table?

I hope my "Reputation" check recorded, I can't see where it did. :-(

 

[John Big Booty]

When you click the reputation Icon you should get a popup message saying that you have added to some ones reputation. Beyond that you probably won't see anything else. I just had a look and yes your reputation up did get credited, thank you

If you want to open your form showing all records but got to a new record you could use the DoCmd.GoToRecord method in the Form's On Load event to Go To a New Record. Another thing you can do is to set the form's Data Entry property to True in the Form's On Load event. This would open the form with all existing records filtered out, only allowing the user to enter new records and view those records entered in the current session of the form.

 

[RustyRick]

"If you want to open your form showing all records but got to a new record you could use the DoCmd.GoToRecord method in the Form's On Load event to Go To a New Record. "

I'm missing some syntax here?

 

[John Big Booty]

It should look like;

DoCmd.GoToRecord acDataForm, "YourFormName", acNewRec