New Record?

  • Thread starter Thread starter Guest
  • Start date Start date
1. Set focus to the subform control.
2. Set focus to some control in the subform.
3. Go to new record.

This kind of thing:

With Me[NameOfYourSubformControlHere]
.SetFocus
.Form![SomeControlNameHere].SetFocus
If Not .Form.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If
End With
 
When you add a newbutton the button wizard should start. Just select the
Record Operations category, and the Add New Record function. That will create
all the code for you.
 
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

Command button on a continuous form 2
Save a macro button onto a toolbar 7
image attachments 9
New record in bound form 1
Adding new records to subforms 3
Pop-up form that creates record that links 1:1 to main form 0
New record in subform with Access 2000 3
Creating PK via code 3

Back
Top