Updating on field (triggered by another) on a specific record.

[Mr.Kane]

I was unable to find any related posts, so I'm submitting my question
to the Group.
If anyone can direct me to a specific thread, then thankyou ahead of
time.

I have a small "process-tracking" db and I am trying to develop a
"update event" where
on a specific record, when the "Status" is updated (via a form) , the
"Status Date" field is also updated with sysdate Date().

I would like this process to be driven from the main form.
My current design has an AfterUpdate event on the "Status" control on
the form tied to a Macro.
The Macro has a "Run SQL" action which is merely an Update Query.
My problem is that I am unable to tie the update query to the specific
record in the form.

I was thinking that I could add Form!MyFormName.Unique_Identifier to
the field that should be updated with Date()

Any help would be appreciated. I can further clarrify my design if
need be,

Marc Kane

 

[Guest]

Hi Mr.Kane,

Simply have your after update event set the value of the field on your form,
no need to use SQL. eg:

me.[STATUS DATE] = date()

Hope this helps.

Damian.