Txt box to show name & if Jr/Sr

chellebell1689

Registered User.
Local time
Today, 11:40
Joined
Mar 23, 2015
Messages
267
Hello,
I created a text box on a form to show the member's first and last name. Works great! I now want to add it to show if they are a Jr. or a Sr. I thought I knew enough to make it work, but now instead of the name it just shows "-1". Here's the expression in the box...(if possible I'd like to keep it as an expression, since I'm still new to the "behind the scenes stuff" and don't know VBA)

=[GoesBy] & " " & [LName] & " " & IIf([IsJr]=True,"Jr",0) Or IIf([IsSr]=True,"Sr",0)
 
Disregard this! I decided to go with a drop down menu (helps if the member is a III or IV or whatever). If someone would like to answer it in case someone else wants this, I will gladly check to see if the fix works.
 

Users who are viewing this thread

Back
Top Bottom