I feel like my brain is just going in circles and I can't figure this one out.:banghead: I have one form, Issue Escalation Screen, which has some data pulled from a previous table and some new data input. A key input field is RESOLVER. When a button (TEMPLATE) is pushed on this screen, a query is run against the RESOLVER field and another table to find the name of the Template Report that should be opened. When I had just a few it was an easy case of if/then statements, but I now have a full array with a dozen reports. I know this should be a relatively simple case of some sort of lookup but I seem to be suffering from brain fog.
Thanks for your help.
Thanks for your help.