Auto-populate current date and time when other fields completed

[SJLyall]

Hi
I have a table called Neutron2015. I want the current date and time to complete when entries are made in two other fields. So I am looking for this date and time to populate in EXLStart when an entry is made in Processed By, and also the current date and time to appear in EXLEnd when an entry is made in Completed By with the bold word being the field names.

Is this possible, and how difficult is it?

Thanks

 

[spikepl]

It is. Not very. Get cracking and post if stuck.

And why do you have a table called Neutron2015? It implies there might be a se3parate one for 2014 or 2016 and that is wrong. You don't have a wallet for January , one for February and so on, do you? Similar stuff goes into one table. This is likely a breach of normalization which will condemn you to eternal PITA and a lot of extra superfluous work.

 

[SJLyall]

OK. I have the completed and EXLEnd piece working using the coding below:
Private Sub Command44_Click()
On Error GoTo Err_Command44_Click

DoCmd.GoToRecord , , acNewRec
Exit_Command44_Click:
Exit Sub
Err_Command44_Click:
MsgBox Err.Description
Resume Exit_Command44_Click

End Sub


Private Sub EXLEnd_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub EXLEnd_Click()
End Sub
Private Sub Completed_AfterUpdate()
Me.FinishedTime = Now()
End Sub
Private Sub Completed_BeforeUpdate(Cancel As Integer)
End Sub

I am however stuck on getting the EXLStart piece to populate with current date and time when and entry is made into Processed By.

Can you assist me with that please?