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.

 

[Pat Hartman]

In a database that will be used by others, you should not be opening queries. If the query is updateable and most are, you have no way of preventing the user from updating the data. You should use forms since you can prevent editing data if you need to. Once you go with a form, it is quite easy to add a close or back button to return to the switchboard. If you want the form to be in datasheet view, it needs to actually be a subform on an unbound main form. For now, stick to a continuous form since it will be less work for you.

 

[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!