Adding new record in tabular form.

[KLR]

I have a tabular form set up and I want the user to be taken straight
to the add new record line right at the end when the form is opened.

How do I do this? It must be simple! (Bit like me).

 

[Rick B]

I believe one way is to set the form's data entry property to TRUE. This
does have other effects though. The user will not be able to use that same
form to view previous data.

Another way is to add code to the form's open event...
DoCmd.GoToRecord,,acNewRec

 

[Brian Bastl]

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

HTH,
Brian

 

[KLR]

That's great thanks. I had used a macro for this but adding those 2
lines of code is much easier. Thank you!