either one of 2 forms can update the field

[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

 

[Douglas J. Steele]

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!

 

[Mr. B]

Frank,

As long as the DateUpdated field is an updatable field (not being returned
by a query that will not allow for editing records) then there is no reason
that the same field cannot be updated by more than one form. The same VBA
code that you are using in the first form should also work in the second form.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm