J
Jody
I am working on a db that was developed in 2003 but I am now using 2007.
This db tracks nonconformancies and there is a "date initiated" but not a
"date closed". I am charged with building a report that shows how long
something was "on hold" (i.e. the duration of the job from initiation to
close). There is a combo box with a status of "Open" and "Closed" in which
"Open" is the default value and the user selects "Closed" when the job is
complete.
Here is my problem: I need to have the "closed date" (that I added to the
table) automatically populate with the date the person changed the status. I
initially built an update query that will set the date to =Date() and this
works great for setting ALL of the dates at one time, but I want it to only
affect the record being put in the "Closed" status. I attempted to do this
by creating an Event Procedure to run OnChange attached to the Status combo
box as "doCmd.OpenQuery, DateClosed" but I had no success with this.
Am I going about this all wrong?
This db tracks nonconformancies and there is a "date initiated" but not a
"date closed". I am charged with building a report that shows how long
something was "on hold" (i.e. the duration of the job from initiation to
close). There is a combo box with a status of "Open" and "Closed" in which
"Open" is the default value and the user selects "Closed" when the job is
complete.
Here is my problem: I need to have the "closed date" (that I added to the
table) automatically populate with the date the person changed the status. I
initially built an update query that will set the date to =Date() and this
works great for setting ALL of the dates at one time, but I want it to only
affect the record being put in the "Closed" status. I attempted to do this
by creating an Event Procedure to run OnChange attached to the Status combo
box as "doCmd.OpenQuery, DateClosed" but I had no success with this.
Am I going about this all wrong?