Macro Command

Hi All:
Is there a such command that would allow me to run the following line of code:

oLstSpkr = IIF(oRecData!Option_Name = "Speaker","Set oLstSpkr=LstPSpeak,Set oLstSpkr=LstSndSpkr)

&oLstSprk --(run whateve is in the oLostSprk)

Thanks
:eek2:

It is possible, but I would recommend using a normal If rather than IIF, as the IIF always evaluates code for both the True and False results (which could well be a problem as there are objects invloved).

VB Code:

IF oRecData!Option_Name = "Speaker" Then
  Set oLstSpkr = LstPSpeak
Else
  Set oLstSpkr = LstSndSpkr
End If

Thanks si_the_geek:thumb: