• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 771
  • Last Modified:

event for next record in continuous form

I have a continuous form, each record has several fields that may be updated. I want to update the PostedBy field and PostedDte field if that particular record was changed. I'm thinking of using the "Dirty" function on leaving one record and going to the next to update that info prior to writing the record. What event (and where is it) gets control when I try to move to the next record?
0
ronallard
Asked:
ronallard
  • 2
  • 2
1 Solution
 
ahmedbahgatCommented:
access xp forms has On Dirty Event, you may try it

cheers
0
 
ronallardAuthor Commented:
Sorry this is Acc-97, that would be no use to me...
0
 
ahmedbahgatCommented:
then you may use dirty function within  the On current event of the form

cheers
0
 
MrRobinCommented:
If any fields have been changed then the form's Before Update event is fired just before Access saves the changes.  You could try the following sort of code...

Private Sub Form_BeforeUpdate(Cancel As Integer)
    PostedBy = CurrentUser
    PostedDate = Date
End Sub
0
 
ronallardAuthor Commented:
Thanks - That worked just like I wanted it to!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now