I need to run a query to return data on multiple customer numbers. I have a form with a text box. The query's criteria is based on the text.
If I manually input the criteria in the query as Customer_Num in(100,200,300) it works. When I input 100,200,300 in the text box of the form, the query (Customer_num in([Forms]![frm_Main]![txtCustomer#])) it returns no rows.
Thanks in advance for your help!