Running a query or table in a form

[Katherine]

When running a query or a macro to open a table in a form (through a command button), it opens the query/table but sometimes when you click the cross to close the window it closes the form and not the query/table. Even though the query/table is brought up the tab at the top of the query/table is not bold and highlighted. It doesn't do it every time but usually when you try to run a query/table for the first time. How do I get the query/table tab to be selected so when I close the window it closes the query/table and returns back to the form?



Would I need to convert the macro into VB code and add something into the code so it stops doing this?

[rpeare]

if you're using the docmd.opentable or docmd.openquery commands it's going to open a separate window. If you've got a list box or subform etc that's based on your query you can just refresh the results and not have to worry about this closing problem