Hi all.

I'm attempting to create my first Custom Ribbon in MS ACCESS 2007 and need a bit of assistance.

I have one (1) tab with two (2) tabs. First tab is merely an EXIT whose OnAction Closes all open forms and Quits ACCESS.

The second tab contains two (2) Items which are responsible for opening two (2) different forms handled in the OnAction sub

When my app opens I would like to have both of these enabled so the end user can select one or the other to open. When the user chooses the first form, I would like to disable the second form until the first is closed and visa versa. I am storing True or False in a global variable so that the GetEnabled sub can reference the value and assign it to the control.

Any assistance is appreciated.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
          onLoad="OnRibbonLoad">
  <ribbon startFromScratch="false">
    <tabs>
     <tab id="tabVisionUtilities" label="Vision Utilities">
        <group id="grpExit" label="Exit App" visible="true">
          <button id="btnExit" size="large"
          label="Exit" imageMso="GroupColorModeClose"
          onAction="OnActionButton" />
        </group>
        <group id="grpApps" label="App Launcher" visible="true">
          <button id="btnMCF" size="normal" label="Mainframe Credit Files"
                  screentip="Create Mainframe Credit Files"
                  imageMso="ExportTextFile"
                  onAction="OnActionButton"  getEnabled="GetEnabled"/>
          <button id="btnSQL" size="normal" label="SQL Template"
                  imageMso="SqlSpecificMenu2"
                  onAction="OnActionButton"  getEnabled="GetEnabled"/>
        </group>
      </tab>
    </tabs>
  </ribbon>
</customUI>