On Click add note to subform

[cktcPeterson]

I have a check box that when I click on, I want to add a record in my notes subform that says emailed then also populate the date.

So on the main form I have check box [email_approval]
Subform- Contact Notes subform1

2 fields
Notes
NoteDate

Thanks

 

[June7]

Options:

1. INSERT action SQL to enter record into table subform is bound to then requery subform

2. Set focus to subform, move to New Record row, populate fields

3. Open RecordsetClone of subform RecordSource, add record to RecordsetClone which will be reflected in the subform data

 

[cktcPeterson]

How do I setup the set focus?

 

[June7]

Forms!mainformname.subformcontainername.SetFocus