URGENT: (being deployed USAR) commandbar help needed

[LikeThisName]

Thanks in advance

I need to reference my toggle buttons.

i know how to script a function when a toggle button is pressed but not reference it from another function which is what i need.

in my reports i need to to select from two queries depending on what the togglebutton is up or down its .State

i tried to use if statements in a with cc statement
but what do i set cc as
application.commandbars("MyMenu&quot.controls("Control3&quot??

do i use actioncontrol? findcontrol? how?

please help i leave in october, just got the news that my unit is being activated and i need to complete this b4 i go.

 

[LikeThisName]

It'd still be nice to know. But I know i can take the togglebuttons of the commandbar and put on a form and reference them from there. or i could make the commandbar toggle buttons not toggle buttons and just have the person select the report after they press the button.

 

[LikeThisName]

hey i got this to work

Dim cc As CommandBarControl

cc = CommandBars("MyMenu&quot.Controls(3)
If cc.State = msoButtonDown Then
cc.State = msoButtonUp
Else ...

i'll try to post a FAQ on this B4 i trade my pc for my m16.

me deploying couldn't come at a worse time, but really, when is a good time to go to war. i just hate being a political pawn, i signed up to defend my country.