I am trying to figure out a way to allow a access user create a query for
report through a form. Can someone help with this?
Depends on how much flexibility you want to give the user. What's the
context? If it's just using a Form field as a criterion, you can use
=[Forms]![YourFormName]![YourControlName]
on the criteria line in your query, and put a command button on the
form to launch the report based on the query.
If you want to replicate the complete functionality of the query
design window... you're not only in a different ballpark, you're
playing a different game!
John W. Vinson [MVP]