peispud
asked on
Access 2010, Save info to varaible just before new record has been written
Hi
I am using access 2010
I would like to record the value of a data field just before a NEW record has been saved.
I tried the code below, but....
public strLastDataEntry
Private Sub Form_AfterUpdate()
If Me.NewRecord = True Then
strLastDataEntry = [myfield]
End if
End sub
I am using access 2010
I would like to record the value of a data field just before a NEW record has been saved.
I tried the code below, but....
public strLastDataEntry
Private Sub Form_AfterUpdate()
If Me.NewRecord = True Then
strLastDataEntry = [myfield]
End if
End sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER