Adding records with a subform

I am using a subform  which I bound to an SQL string to display a filtered datasheet of records  for a specific client. I am using the code shown below to bound the form to the SQL. The tbl-personalNotes table has 4 fields: NotesID(Autonumber), ClientID, NoteTitle and NoteTxt. The subform displays the NoteTitle and NoteText.
How can I insert a new record to the table, and at runtime assign the ClientID field in that record to be the value contained in the variable newclientID?

When I enter the record using  ClientID gets automatically a 0 value, and it needs to be equal to the value of the variable newclientID

How can I add a record using a subform, but Start Free Trial

1:
2:
3:

SQLstr = "SELECT * FROM tbl_PersonalNotes " & _
         "WHERE ClientID = " & newclientID
    Me.notesSbFrm.Form.RecordSource = SQLstr