Resetting value in Subform as soon as a record is added on Main Form

[kruger101]

Hi guys
Couldn't find anything like this in the forums.
I think the title explains it really. As soon as I add a new record on the Main Form, I want to reset a number field on the subform back to 0.
I tried using a macro and the NewRecord method in VBA, but I couldn't get it to work. I thought the macro would work, but it said "No subform found" and I'm sure I used the correct name.

Thanks
kruger101