Go to last record

Hello,

When I open a form in Microsoft Access I want the form to go to a new record that can be filled in. How do I do that?

Greetings.

Is this an Access form or a VB form?

Quote:

---

Originally Posted by IwanVerrips

Hello,

When I open a form in Microsoft Access I want the form to go to a new record that can be filled in. How do I do that?

Greetings.

---

This would get more replies in the microsoft forum.

I'm guessing you have the 'columner' view of the form, I dont know how to do it for the columner view but if you create a new form and use the tabular style then the new record will always be at the bottom of the form.

Chris

Quote:

---

Originally Posted by Hack

Is this an Access form or a VB form?

---

It is an form in Access, but I'm going to edit the VB code.

VB Code:

Private Sub Form_Open(Cancel As Integer)
 
End Sub

What must come between these?

This is a question about VBA(Visual Basic for Application) so hopefully a mod will move it to the VBA section where the VBA experts will read it.

Chris

Quote:

---

Originally Posted by IwanVerrips

It is an form in Access, but I'm going to edit the VB code.

---

Actually, you will be using VBA.

Access VBA question moved to Office Development

If you change the DataEntry Property of the form to TRUE, the form will automatically open with a blank record.

Private Sub Form_Load()

DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acNext
End Sub