How can I create an Ad Hoc Query on a form? I have a form with a subform designed as a Datasheet. The subform contains approximately 10 headers and is sourced from a query. The top form currently contains a combo box that sorts the datasheet based on the first header. What I would like to do is give the user an option to sort by any field or combination there of s/he wants... similar to Excel's AutoFilter function. What is the best means by which to do this? Thanks for any advice. thehorse