Hi all, it's a number of years since I was a member here before. Back using Access/VBA/SQL after a long absence. I'm having trouble with getting a global variable and/or a form field value to work as a criteria in a query. I think it's because the values are an array. I'm getting the multi values from a list box and outputting the string value to a textbox. When I copy in the string value it works perfectly as the Criteria for the query, I know this is not good practice, but it's fulfilling a need (unless anyone has a better suggestion for getting multiple criteria into the query - I would be most grateful to hear of it). The array works as IN("Item1","Item2",Item3,ItemN), but when I add that string to a get_GlobalVariable() it doesn't work, nor getting the value directly from the Form textbox value. Any help with this would be appreciated.