Changing a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to update one field in a table with the current date, if any data changes in any of the controls on a form. How do I d
this and which event would I use

Thank you
 
John said:
I need to update one field in a table with the current date, if any data changes in any of the controls on a form. How do I do
this and which event would I use?
Click to expand...

Assuming the form has a text box named txtDatechanged
that's bound to the DateChanged field in the table.

In the Dirty event:

Me.txtDatechanged = Now()
 
John said:
I need to update one field in a table with the current date, if any data changes in any of the controls on a form. How do I do
this and which event would I use?
Click to expand...

On second thought, I think it might be a little cleaner and
version independent to use the Form's BeforeUpdate event.
 
Back
Top