last record upon form load

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a create new button on a form and upon opening of form, i want it to
default to a new (blank) record. how do i do this?
 
This code will open a form as a new record

Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "yourFormName"
DoCmd.Close
DoCmd.OpenForm stDocName, , stLinkCriteria, DataMode:=acFormAdd
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
extra record in continuous form 4
acnewrec? 1
A Go To Box in a Form 2
Same value written on all records automatically 2
new record and form 4
Pop-up form that creates record that links 1:1 to main form 0
Opening a database with a new form 3

Back
Top