Trying to Use a Function to Set a String Variable

[RunTime91]

Greetings All...

Again, seems like it should be easy.... buuuut, here I am...

So, what I am trying to do is set the value of a string variable equal to the result of an Iif Function...



(based on the fact I can't even get it to stop turning red...I'm not even close.

Dim TAdd As String
Set TAdd = (Iif Me.CmboSalesList.Column(2) = "Null" Then "Yes", "No")

I'm trying the idea of using a SQL statement as you read...But I hope from the above you can capture the idea I'm going for

And... As Always - Thank You Guys Very Much...

[isladogs]

Your syntax is completely wrong and you are mishandling doing null check
Remove the Set and rewrite as follows

TAdd=IIf(IsNull(Me.cmboSalesList.Column(2)),"Yes","No")

[RunTime91]

Geez... I was backwards...and possibly inside out...

Works perfectly ~

Thanks Ridders!

[isladogs]

Upside down as well...
Anyway glad to have helped