Solved New Record in Subform and auto populate field (1 Viewer)

stu_c

Registered User.
Local time
Today, 00:15
Joined
Sep 20, 2007
Messages
489
For anyone that needs it, here is what worked for me :)

Code:
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
 

Users who are viewing this thread

Top Bottom