I have a button on a form in Access that executes a macro. The macro triggers a query to find all of the email address's of people enrolled in a certain class. When the button is clicked, a dialog box comes up and asks for a workshop number. The user enters a particular number, clicks Ok, and the email address's are displayed in Notepad. However, when the dialog box comes up, and a user clicks Cancel, it still opens Notepad(without any email address's being displayed) and asks me if I want to create a new file. Is there any way to make the dialog box Ok only?