Combobox in Navigation Form

[tazzzz]

Hello all,


I have a Navigation Form with multiple subforms(tabs). Each subform has a combobox that allows me to view data for a specific piece_number. I would like to eliminate all this comboboxes from tabs and use only one combobox in Navigation Form that will allow me to see data (when I select a tab) for the value selected in main combobox.
Any advice to achieve this is greatly appreciated.
Thanks.

[ranman256]

On the ON CHANGE event of the tab,
change the query / form in the sub form depending on the tab page clicked.
The combo box can further filter the records in the subform.

Private Sub Tab1_Change()
Select Case Tab1.Value
  Case 1  'grades
     chd.SourceObject = "frmGrades
    
  Case 2  'students
   chd.SourceObject = "Query.qsStudentList"
  
  Case 3   'Classes
      chd.sourceobject = "frmClasses"
End Select
End Sub

[June7]

I don't like and don't use Navigation Form.

I also don't like and don't use dynamic parameterized queries.

However, a dynamic parameterized query for each subform might be the simplest approach when using Navigation Form.

[tazzzz]

One of my Tab properties shows only "On Selection Change''; "On Data Change" and "On Data Set Change". Which one should I choose?
Also, What is Tab1? For each tab should be only one case?
Thank you

[June7]

Possibly ranman was thinking of a Tab control. I don't think suggested code will work with Navigation Form.

I see those events on the main Navigation Form, not on the 'tab'.

[tazzzz]

So you think there is no way to select data in tabs based on a combobox in Navigation Form?
If I keep the comboboxes in tabs is there a way to make them show the same data as the combobox in Nav Form? Basically, selecting something in "main"combobox will make the other to show the same thing?

[June7]

I already suggest one possible approach in post 3. Dynamic parameterized queries would refer to the combobox as filter parameter.

[tazzzz]

Parameter query and dynamic parameterized query are different? I am familiar with the first one but I don't know anything about the second one.

[June7]

Dynamic means the parameter is not static, it is provided by user input. The user input can be from a popup within the query (do not recommend this) or by reference to a control on form.

Not dynamic:

WHERE FiscalYear = 2015

Dynamic with popup:

WHERE FiscalYear = [enter year]

Dynamic with control reference:

WHERE FiscalYear = Forms!MyForm!cbxYear

[tazzzz]

Ok, thanks for explanations. I have been using all the time dynamic parameter queries without knowing the real name. To call the combobox from the query should I use this: [Forms]![MyNavigationFormName]![Combobox]?

[June7]

That looks good. Try it.

As I said, don't use Navigation Form. I am not sure if code will be required to requery/refresh the subform after selection in combobox.

[tazzzz]

I will let you know how is working. Thanks for the help.

[tazzzz]

[Forms]![MyNavigationFormName]![Combobox] is not working. Is there another syntax to refer to a combo from main Navigation form?
I can make it work from subforms but not from main Navigation form.

[June7]

What do you mean by 'not working', what happens - error message, wrong results, nothing?

AFAIK, that is correct syntax. But I've never used Navigation form.

If you want to provide db for analysis, follow instructions at bottom of my post.

[tazzzz]

I mean the query will not populate with data when using combo from main Navigation Form. Using combo from subforms works nice without problems. I thought perhaps something is missing on my syntax.