How to delay part of code until WMP finishes playing?

[rwahdan1978]

Hi



I have the following code:

            WMP3.URL = "C:\Users\ramit\OneDrive\Desktop\images\correct.mp3"
            DoCmd.OpenQuery "updateAhmad"
            AhmadScore = AhmadScore + 100
            Forms("main").ahmad = AhmadScore
            Forms![Main].Visible = True
            DoCmd.Close acForm, "form1"

It is ok but since I am closing the form and opening another form the player is not playing. I want to play the sound then do the rest of the code. How o do that? I tried the sleep option but it is freezing everything even the player then goes to the new form.

[CJ_London]

If you know how long the sound plays, try the pause function

[June7]

Review https://stackoverflow.com/questions/...layer-finishes and https://learn.microsoft.com/en-us/pr...93473(v=vs.85)

[Edgar]

You could have the player in a hidden form dedicated to sound. Or have the player in a form that never closes, like possibly the main form.