Return to switchboard from Query results

[deek60]

Hello, I hope this is the correct place to ask this....I have a 2007 DB of my music collection. I used the Switchboard manager to create a switchboard for users to run searches such as performer, album or song...so here's my problem I want to share the db in read only mode...all works well it opens to the main SB in full screen....but if a user runs a search query....there's no way to get back from the data sheet of returned information to the SB...is there a way to embed a macro in the datasheet to put a back button or return to "main menu" button....I'm not a code writer....so please be kind

 

[Steve R.]

Open forms tend to be "stacked". Assuming that you have two open forms after executing the query returning to the switchboard would normally occur when you close the form on which the query appears. To return to the switchboard, i usually have the results of a query displayed as a datasheet in a subform embedded in a main form. The main form contains a close button that closes the form which returns the focus back to the switchboard.

 

[deek60]

Thanks for the replies! I did change to a form and built one that can be saved, printed or closed. I'm just learning what cool things I can do with Access.......I'm sure I'll have more questions! Thanks guys, and have a great day!