From the navigator I'd like to open a form and auto-fill the created by & time fields. I've tryed using (in comments below) me.field name and formname.fieldname and both error out? Any suggestions...
Private Sub Command45_Click()
DoCmd.OpenForm "frmCustomer", , , , acFormAdd
'me.CreatedD_T.value = Now()
'frmCustomer.CreatedBy = CurrentUser()
End Sub
Thanks!
Private Sub Command45_Click()
DoCmd.OpenForm "frmCustomer", , , , acFormAdd
'me.CreatedD_T.value = Now()
'frmCustomer.CreatedBy = CurrentUser()
End Sub
Thanks!