I have a form with buttons that have a macro to open up queries. Why is it when I click the button and it opens the query, it does not switch to the datasheet view of the query? My form will stay as the active window and I have to either close it or minimize it to see the datasheet that is behind the form window. Is there a way to control when to switch to the datasheet and when I want to go back to the form from the datasheet?