popup control button

[KevGooss]

I have an application which filters records based on user input. At some points the user can select to see the results of a query that will subsequently be used as the basis for a report. When these results come up on the screen they are in datasheet form (they appear like an Excel spreadsheet). My question is this: I would like for a small button to pop up on the screen that says "close" and when clicked closes the query output. I realize that all the user needs to do is click the small x to close the screen but that is not always obvious to all and some hit the top x that closes out the whole program.

 

[Jack Cowley]

Create a form. In that form create a subform that will display the datasheet view of your query. On the main form put a command button that will close the main form. That will close it and the subform and return you to the form you came form....

 

[KevGooss]

Thanks, Jack

I'll give it a go