Add a new record to a subform?

[jimmonator]

I have a form which contains a "Notes" subform, which is linked to a Notes table. The subform has the control bar turned off. I want to add a simple button which will add a record to the Notes Table and subform. I know how to get to the button's properties and the "event" tab, but I don't know what to write in the OnClick event procedure. All I need is a button which will make the new record and drop the cursor into position for a new note to be written. Can anyone help me with this?

[ketbdnetbp]

Assuming the subform's recordsource is the Notes table or a query based on the Notes table -

In the Buttons: OnClick event [EventProcedure], you could try:

Dim strSubformControl As String
strSubformControl = "NameofSubform"
DoCmd.GoToControl strSubformControl
DoCmd.GoToRecord acActiveDataObject, , acNewRec
DoCmd.GoToControl "NameofNoteControl"


All the best,

Jim