Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a List box for a field named Manager with all manager names under it. Based on the name being selected on the manager field, the text box should display the message. Eg: If John is in the manager field and if he is selected, then the text box should show as 'John's Monthly Report', if another name Joe is selected, then it should change as Joe's Monthly Report'.
Thanks
May be like this
=Manager & Chr(39) & 's Monthly Report'