Trying to make a label on a form

[RichB]

I am trying to make a label (below) on a form and it works if I leave the FirstName off. I want it to have last and first name.

Private Sub Form_Current()
Me!TabMember.Value = 0
lblName.Caption = IIf(IsNull([LastName]), "", "Member: " & [LastName], [FirstName])
End Sub

I'm sure it's simple but I'm tired today. Thanks Rich

 

[wh00t]

try

lblName.Caption = IIf(IsNull([LastName]), "", "Member: " & [LastName] & "," & [FirstName])

 

[RichB]

I must have made a mistake because I tried that first and it would not debug with out errors; which is how I came up with my first post.

I copied and pasted yours and it worked.

I appreciate your time.
Thanks
Rich