Pressing Tab to add a new record at the end of one record in a for

[briangw]

Back in Access 97 and 2003, I noticed that when you reach the end of a record
in a form and press tab, it used to take you to a new record. But, in Access
2007, it's not doing that. Please let me know what I need to check for to
enable this function.

 

[Jeff Boyce]

There's a form property (Cycle) that affects how a <Tab> affects the screen.

You can set it to (re-)cycle back through the fields of the record you're
on, or move to the next record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[briangw]

Thanks! That worked! One more question. How can you setup the form to
automatically start at a new record upon opening the DB without hiding the
previous records? Whenever I launch the DB, it always starts at record 1.

 

[Jeff Boyce]

Are you saying you want to ONLY add new records? If so, check the form
property DataEntry (=Yes).

(PS ... then how will you edit a previously-entered record?)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Thardy]

It sounds to me like he wants it to be able to add AND edit but open
on a new record rather then number 1.

 

[Jeff Boyce]

Feel free to offer a solution to your interpretation...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

It sounds to me like he wants it to be able to add AND edit but open
on a new record rather then number 1.

if so, put code in the form's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub

John W. Vinson [MVP]

 

[briangw]

Yes, that's exactly what I wanted to do

 

[briangw]

Thank you. I will try that.

if so, put code in the form's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub

John W. Vinson [MVP]

 

[briangw]

That did not work. Under the code builder, I added it, but upon opening the
form, I got

" Run-time error '2105':

You can't go to the specified record."

Any ideas?

 

[John W. Vinson]

That did not work. Under the code builder, I added it, but upon opening the
form, I got

" Run-time error '2105':

You can't go to the specified record."

Any ideas?

Just an apology for posting in haste, and a correction:

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec


John W. Vinson [MVP]

 

[briangw]

It worked! Thanks!

Just an apology for posting in haste, and a correction:

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec


John W. Vinson [MVP]