Go to last record

[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.

[Hack]

Is this an Access form or a VB form?

[the182guy]

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

[IwanVerrips]

Is this an Access form or a VB form?

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

Private Sub Form_Open(Cancel As Integer)
 
End Sub

What must come between these?

[the182guy]

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

[Hack]

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

[DKenny]

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

[noycwild]

Private Sub Form_Load()

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