When the user enters a value in the Input Box, it loops through the values and determines if the record exists or not. It was meant to be only an error message if a record was not found. However, now I need it to display 'All values requested were found in the data set.' if the value is null. I tried an IF statement and kept getting an Error in Expression message. Can anyone figure out what the expression should be?
Also, I would like it to now use commas instead of spaces. The text box currently looks like this:
I want it to say "The following item(s) could not be found: 123456789, 987654321"