Add button to Ribbon to reload form

[Mmmel]

Hello! I want to put a button in a custom group on my custom tab of the Ribbon (Access 2010) that will simply reload the original form that loaded when the database opened (what was in Access Options, Current Database, Display Form:). I am doing a lot of development, and everything keys off of this main form. It's making me crazy to have to hunt it out in the Navigation Pane and re-open it over and over.

Thanks for any pointers!

Melody

[zmbd]

Access Ribbon is a real treat to program.
Here's what I would do for a short term solution.

Ribbon
Home
Create
Macro
Save the macro as Autokeys
On the right (by default) is a table
double click Submacro
in the name enter ^{F12}
click on the dropdown list in the add action and select openform.
Enter the information in the boxes
Save

Now whenever you press {CTRL}{F12} the form will open with the options you set.

I actually trap the {F1} key in my applications with this and open my own "Help" form ;-)

Ribbon design takes alot more effort and if you are REALLLLLLLY interested in it then I'll get the links togeither for you

[Mmmel]

Thanks! I will give this a go.

And, I'm not reeeeeeeally interested, so please don't go to the extra trouble. You'd think that it would be easier, eh? :)

Thanks again!

[zmbd]

One would think that Ribbons would be easier to build.

At least in Access, there is a hidden system table that the XML is stored in that you can access (ha funny) and then there is a callback code between the XML and VBA and you have to learn the XML schema/

In Excel and Word, the XML is hidden within the new file format; thus, you need to either uncompress and pull their files apart or you need yet another program to get at the XML within the file. I have a COM addin for our EXCEL used in the lab that handles routine files and that was a real treat and a word document that has some interesting features and that was even worse... and a whole different program to get at the XML in there!

MS really didn't help the end user!