dialog box

[Christina]

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

 

[Duane Hookom]

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.