need yours help

  • Thread starter Thread starter avi
  • Start date Start date
A

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)
 
avi said:
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)
Click to expand...

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
 
Back
Top