How to perform vba task after media player finishes

How to perform vba task after media player finishes

I'm using Access 2010 and have tables setup to identify a particular video
file. I have a button on a form that will launch the video file with
WindowsMediaPlayer. The problem is that I want to update the table(s)
after the video has run. I've created this quick from a button on a form
(fTest1) but the next part I've been searching around for a while.
Private Sub Command1_Click()
Dim player As WindowsMediaPlayer
DoCmd.OpenForm "fTest2"
Set player = Forms!fTest2!WMP.Object
Forms!fTest2!WMP.URL = "S:\Training Videos\Wildlife.wmv"
' here is where I want to do something after the file has finished
'
I did a test with a msgbox but it shows up while the video is playing.
Looking for like a call or wait until or something.
Any help would be appreciated.