Macro Command

[Zach Ahmed]

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

[si_the_geek]

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).

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

[Zach Ahmed]

Thanks si_the_geek