Sorry to be stuck on this

[NewbieMan]

I know this should be easy but for some..not so much for me

have this code..

Public Sub LaunchGame_Click()


If ChooseYourGameBox.Value = "Game1" Then
ArcadeGames.Movie = "http://www.Game1.swf"


ElseIf ChooseYourGameBox.Value = "Game2t" Then
ArcadeGames.Movie = "http://www.Game2.swf"
End If

Code is supposed to work as follows. I have a combobox named ChooseYourGameBox with a list of games. User picks a game. The command button (named LaunchGame) then should look at what is written in the combox box and load in the appropriate game for the user when it is pressed. That works great the first time. But then if you choose a different game and click the command button to load in a different game it doesnt do anything. So if i pick Game1 and hit the command button its loaded in fine, but then when i want to play something different after, say, Game2 and hit the command button nothing is happening..can someone please correct and if possible please explain (if possible) why this would be the case?

Thanks

 

[Logit]

.

[COLOR=#333333]"Game2t"[/COLOR]

Maybe a spelling error ?

 

[mikerickson]

I suspect that the problem lies with the ArcadeGames object. If it is a user defined class, I'd wonder if the .Movie method clears the existing game before loading a new one.

 

[NewbieMan]

.

[COLOR=#333333]"Game2t"[/COLOR]

Maybe a spelling error ?

Sorry ..thats just an error when I moved the code to the forum. everything is spelled correctly in the actual real code.

 

[NewbieMan]

I suspect that the problem lies with the ArcadeGames object. If it is a user defined class, I'd wonder if the .Movie method clears the existing game before loading a new one.

I dont know. Would there be a workaround? Maybe adding a second command button that would "force" a reset? I tried resetting the command button that launches the game but that had no impact. Or is it possible to add a little code at the end of each if to sort of "force" this to be reset? Any help would be appreciated.
Thanks again.

 

[mikerickson]

Movie is not a property or a method in the VBA object model. Your ArcadeGames variable must be of a custom data class. Without seeing the code for that custom class, it would be impossible to suggest a work-around or a reset code.