Solved New Record in Subform and auto populate field

[stu_c]

For anyone that needs it, here is what worked for me

Public Function FUNC_AutoPopulate()

With Forms!FRMOrderDetails!SFRMCustomerDetails.Recordset
.AddNew

[Forms]![FRMOrderDetails]![SFRMCustomerDetails].[Form]![TxtOrderingDate]= NOW()

'ADD OTHER FIELD ENTRIES HERE

End With
End Function