I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is how to pass the accepted values or criteria to the Queries and Reports in Access. For example, I have a table 'Author' like... Code Name Address NoOfBooks ------ ------- ---------- -------------- 001 ABC 102, aaa 20 002 DEF 203, bbb 57 003 GHI 304, ccc 60 004 JKL 405, ddd 15 . . . . . . . . . . . . I have a query 'QryAuthor' like... Select * from AUTHOR where NoOfBooks >= 50; But at run time user may want to see all authors who have written more than 100 books, then how to pass the value 100 from VB to Access

Software/Hardware used: