I generally have a form open that allows users to enter or select criteria values. You can then persist the values in the form controls for multiple queries or Record Sources.
-- Duane Hookom Microsoft Access MVP
"Christina" wrote:
[Quoted Text] > I have two queries that prompt for a beginning and ending date. I run a > macro to run both queries, and get prompted twice for the beginning and > ending date. I would like to create a dialog box, and need the detail I > would put in the criteria for the query. > > Thanks
|