Using InputBox to Change Query Criteria
Posted on 2008-11-13
I am trying to reduce the amount of queries I have in my database. I have a query, lets say QRY1, that is the data source for multiple forms. I want to use the InputBox to add criteria to that query. I know I can do this in design view of the query, but I have multiple critera depending on the user and I don't want to have QRY1 with the  under one field, the QRY2 (the same tables as QRY1) with  under a different field. Does this make sense? Can this be done with the InputBox? Thanks in advance for all who reply.