Can I record the date that a status field in my table changes

[MattFitzgerald]

I have in my table a field OrderStatus and want to use the now() function or similar to record in a field DateStatusChanged the date and time the status was last changed. How can I do this? and can the code be in the table the data is stored in? or does it need to be in the form that the user is using to change the status?

[missinglinq]

There is no "code" per se in tables. In the code module for your form:

Private Sub OrderStatus_BeforeUpdate(Cancel As Integer)
Me.DateStatusChanged = Now
End Sub

Welcome to TheScripts!

Linq;0)>

[MattFitzgerald]

Thank you:

Me.DateStatusChanged = Now ()

above code worked just as I wished it to. Being the first time I have used code could you explain

Me.

(or a website that has a dictionary of code)

Is there similar code that can be used to give a changed date if any part of a record is updated rather than targeting a specific field?

[missinglinq]

Putting the same code in

Private Sub Form_BeforeUpdate(Cancel As Integer)

will timestamp changes made anywhere on the record when the record is saved.

The Me. is a kind of shorthand, if you will, for the name of the current form.
If you're writing code in the code module for a form named

MyMostFineAndIllustriousForm

and referring to, say a control on that form named

MyTextBox

you could write

MyMostFineAndIllustriousForm.MyTextBox

or you can simply write

Me.MyTextBox

Same thing with, say, requerying the form. Instead of

MyMostFineAndIllustriousForm.Requery

simply

Me.Requery

Linq ;0)>

[MattFitzgerald]

Thank you for answering my question and the further help in understanding it.

[missinglinq]

Glad we could help!

Linq ;0)>