either one of 2 forms can update the field

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

In one form I have the field to show if there is an update, the date will
show the last update, therefore I made this sub:

Private Sub Form_BeforeUpdate(Cancel As Integer)
' Update DateUpdated field
Me!DateUpdated = Date
End Sub

I need also to make the like VBA in the other form which is based on other
query. My question is can I make in other form like this again?

Private Sub Form_BeforeUpdate(Cancel As Integer)
' Update DateUpdated field
Me!DateUpdated = Date
End Sub

Thanks for any idea.

Frank
 
That's fine. Doesn't matter how many forms are updating the same table: set
the DateUpdated field from each, and the last one to fire wins!
 
Back
Top