I have a query (qryConstInsp) that is launched by a command button that has been working well. One of the fields in the query (dateofinsp) has a date prompter in the criteria shown below.

Between [Forms]![frmConstInsp]![txtStartDate] And [Forms]![frmConstInsp]![txtEndDate]

Once the user provides the dates for the prompter and then creates the query datasheet, I would like the system to automatically show a pop up message (form) that asks if the user would like to export the datasheet to an Excel file. The choices on the pop up would be Yes and No. If yes, the data on the query would be exported to an Excel file at a location of the user's choosing. if no, then the pop up message would go away.

Could anyone help me to create this feature? Thanks in advance for your time.

Hi Paul

Take a look at this

Link