New Record?

[Guest]

How can I cerate button in form to go a New Record in subform?

 

[Allen Browne]

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

 

[Guest]

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.