Programming a ComboBox AfterUpdate event with an IIf statement

[RunTime91]

Greetings Experts...

I have googled this to death...review dozens of historical threads here and, well, here I am.

Couldn't be more simple... If user selects "Lb" in the CmbSoldBy ComboBox then the control TxtQty TextBox = "NA" else it remains empty.



I've tried brackets [], I've tried using Me.CmbSoldBy and of course Me.TxtQty - I keep getting a 'Compile Error Expected ='

Private Sub CmbSoldBy_AfterUpdate()


  IIf(CmbSoldBy = "Lb", TxtQty = "NA", TxtQty = "")


End Sub

As Always...

Thank You Very Much

RT91

[Welshgasman]

Just use a simple If Else Endif construct?

Or

Me.txtQty =  IIf(CmbSoldBy = "Lb", "NA",  "")

[RunTime91]

Oh, Good Lord... I'm jsmh

Thank You Very Much, Welshgasman!

Stay warm out there in Wales ~

[Welshgasman]

Oh, Good Lord... I'm jsmh

Thank You Very Much, Welshgasman!

Stay warm out there in Wales ~

I am in Mexico right now.