IM requery event to play sound

[Maarkr]

Hope this makes sense... I have a form that is used by many users, each with
a different front end, used as an instant messenger. Each user has a combo
field to identify themselves, then a message field to type a message, and a
RequestAcknowledge field if they want to get a receipt ack from the
recipient. It works well, and requeries every minute, but I was asked to
play a sound when a message is entered with a ReqAck user so they know they
have a new message. I found a good 'playsound' function that works well if I
use it in my AfterUpdate event where the User (myself)=ReqAck (myself), but
it won't play the sound on another user's machine to let them know they
received a ReqAck message. I understand that the AfterUpdate event only
works if the user updates the combo, so WHAT event or fix do I use to get the
other user's machine to play the sound after the refresh when their User
field = ReqAck field? What event is triggered by a requery of the data on
another user's machine to fire the function and make it sound off?

 

[Maarkr]

Never mind...I figure this junk out after I post the question...I suppose it
makes my mind clearer... I tied the function to the first field on the form
and the On Got Focus Event. Works OK cause it plays the sound on every
refresh until they AckRec.