Scenario:
I have a button that executes a query which returns results in a datasheet. Is it possible to have this datasheet within a form with a close button. I don't want the user to click the close from the file menu. Any help is much appreciated. Please advise.

No comment on this one yet!! Even if is not doable please let me know. I am going to try using a subform within a form. Any comments??

Sounds like maybe you could use a Popup form?

David R,

Yes, you could be right. I'll give it a try ASAP. Thanks.

David R,

I got it to work. I used a form to have a subform - the subform contains the query. This way query opens within a form and user can use close button to close form.

Thanks

That's good to hear, and thanks for 'closing' the thread when you got it to work. It's frustrating to see old posts and wonder if the solution ever worked or not. http://www.access-programmers.co.uk/ubb/smile.gif

David R