Pop up when record is changed. (1 Viewer)

[markdooler]

Hi All

so i have what i believe to be a complicated and probably an impossible thing to try and impliment.

Background

I have a job progress tracker that is updated by multiple users in multiple sites.

it controls access through a log in feature.

There is a split form view datasheet that pre filters the jobs into site and then into user.

There is a "current status" filed that is updated as the job progresses through its life cycle.

due to how it works the data is pulled together via a union query and displayed on the form.

What i was hoping for was a popup that notifies the user when the "current status" field changes.

I have added some code for a popup to afterupdate event but this isnt working.

Any ideas?

 

[arnelgp]

you need the Pop-up form to be Opened, hidden.

initially on the Load event of the form, you save
the current value of the field.

add code to the Timer Event of this form that
Dlookup() the "current status" field of your table
and compare it to the "initial value".

when there is change in status, you make the
form Visible.

 

[markdooler]

you need the Pop-up form to be Opened, hidden.

initially on the Load event of the form, you save
the current value of the field.

add code to the Timer Event of this form that
Dlookup() the "current status" field of your table
and compare it to the "initial value".

when there is change in status, you make the
form Visible.

Ok thanks.

Will need to do some research and learning on this.

Aprreciate the suggestion.