Search results

Howdy guys, hope this is the right place to post this. I can't get this nested IIF to work; not sure what is wrong.... name...

I have a form with a text box. I need the text box to show value_2 if value_2 exists, otherwise select value_1. Apparently, my Iif statement for the Record Source does not cut it: IIf(IsNull([value_2 ]) Or [value_2 ] = "";[value_1];[value_2 ]). The formula itself appears to be wrong... Fair...

Well hello! Dutch guy here. I found this forum whilst looking for the answer to my question. Couldn't find it, so here I am! I chose this forum since it appears to be one of the livelier ones in terms of activity. I hope to learn a lot here and in the future perhaps even help out a little...