Send paramter from navigation to another navigation

[ilanray]

Hi
I have a navigation form called "main_menu" with 2 button called "navigationSubForm7" and "NavigationSubForm9" with sub-form inside caled "F_Title".
When I am at navigationSubForm7, I would like to click on a button and load NavigationSubForm9 with a parameter I am sending. this parameter will go into checkbox and load the record I want . Then load the sub-form "f_title" with the same parameter
it suppose to be something like :

private sub tt_Click()
    [forms]![main_menu]!...... [choosestatus]=2
End Sub

the [choosestatus]=2 is the number I would like to input in my combobox

any ideas?

Thanks, Ilan

 

[Ranman256]

'assuming [ChoosStatus] is numeric:

docmd.openform "NavigationSubForm9", , , "[choosestatus]=" & cboBox

 

[arnelgp]

it is still unclear to me of what you need to do.
to Filter the ""NavigationSubForm9" you use:

DoCmd.BrowseTo

    DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
            ObjectName:="F_Title", _
            PathToSubformControl:="main_menu.NavigationSubform", _
            WhereCondition:="ID = " & Me.ID
      
           Forms!main_menu!NavigationSubForm.Form!chooseStatus = [cboBox]

much easier to understand, if you can upload a sample db.

 

[ilanray]

thanks for the anwer, stilll doesn't work
let me try to explain: i have main form called main menu. in the first navigation form called navigationSubForm7 I have 5 buttons. I would like to make an event click on each on eof them (5 buttons) . the event will send the number according to the button I click.
this will load the navigationSubForm9 and input on a textbox the number I sent

 

[ilanray]

That's exactly my question. How do i call the other navigationSubform9 from navigationSubFotm7