How to go back from datasheet query to form

[data808]

I have a form that when you click a button it will close the form then show you the datasheet query. How do you make a macro to go back to the form from the datasheet when you are done viewing it?

[June7]

The only code tables and queries can have are data macros (for Access 2010 and up).

Why open a query? Open a form or report bound to the query. Have code behind form to reopen the other form.

[data808]

Great idea. Thanks. I'll try that.

[data808]

Oh wait. If I made a form thats bound to a query, is there a way to make the form display a list of records that I can look at without having to look at one record at a time? Thats the reason why I liked the actual query in the datasheet view because it shows me a list of records. I would like to try the form way rather than report because you can't put a button to click on to do a macro to go back to a previous form can you?

[June7]

Form in Datasheet View looks like a table/query but buttons won't show. A form in Continuous View can be made to look almost like a table/query by rearranging controls horizontally. Basic form design options.