need yours help

[avi]

I have a form that contens list of prices. I wold like when i update the
filed of price that automatic will update the filed of date of typeing the
both in the some file (pro)

 

[Arvin Meyer]

I have a form that contens list of prices. I wold like when i update the
filed of price that automatic will update the filed of date of typeing the
both in the some file (pro)

One line of code in the BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_Handler

Me.txtDateUpdated = Date

Exit_Here:
Exit Sub

Err_Handler:
msgbox Error$
Me.Undo
Resume Exit_Here
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access