link to a subform field from the main form

[sk88]

Seems like nothing I have so many questions today.
I have a main form and a sub form. The main form have a command button where when I clicked, the Sub form text fields should be empty or cleared.



How do I refer to that of subform from the main form?

This is what I have now and its not working.

Me.Forms![frmAuditAddNewMain]![frmAuditAM].Form!Text123 = ""

Thanks

[aytee111]

me!subformname!textboxname=""

The subform is just another control on your main form and can be referred to as any other.

[sk88]

me!subformname!textboxname=""

The subform is just another control on your main form and can be referred to as any other.

Thanks aytee! It works but now I actually realized thats not what I thought it would give me.

I actually is looking for a ADD NEW button/command in the main form for the subform.

so which means all my information in the main form will stay the same except the subform when I click add new button from the main form.

How do I do that?

[aytee111]

You know, I actually have no idea how to do that! I have been playing around with a few different methods but I couldn't get any of them to work. The only way I succeeded is to put the Add New button on the header of the subform with the following OnClick code:
DoCmd.GoToRecord,,acNewRec