Adding new record in tabular form.

  • Thread starter Thread starter KLR
  • Start date Start date
K

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).
 
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
 
Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

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