Hi All

I have a frontend in excel and backend in access. There is a userform1 ,when the user clicks on that ,It should run a access query and display the result on the screen. When the user close the screen,then the userform should be displayed.

Can anyone please give me the code for this?

Thanks
Aman