Navigation control

[bilalo]

I have a form "Form1" that contains a navigation control with five navigation buttons and a subform. The five buttons all have the same target form "Form2". I need from each button to apply a different filter on Form2 and shows the result in the subform.

I tried to add filters on the click event of the navigation control buttons of "Form1" but it showed me an error(control is not bounded or something like that)
I also tried the Form_Load() of "Form2", I tried to get the tabindex of the navigation control to find which button was clicked in order to apply the correct filter but it always returns 0.
Any help please

[ranman256]

if you want to filter Form2, put the controls on form2, then the code is:

'----------------
sub btnFilter_click()
'----------------
dim sWhere as string 
sWhere = "1=1"
if not IsNUll(cboST) then sWhere = sWhere & " and [State]='" & cboST & "'"
if not IsNUll(cboCity) then sWhere = sWhere & " and [city]='" & cboCity & "'"
if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'"
If sWhere = "1=1" Then
  Me.FilterOn = False
Else
  Me.Filter = sWhere
  Me.FilterOn = True
End If
end sub

[Micron]

You can use the navigation control selectedtab properties: caption or name. Name is probably cryptic value; caption probably more intuitive to you.

Forms![navigation form].NavigationControl0.SelectedTab.Caption

assumes you kept the default name for the nav form (navigation form) and default for control, which may or may not end in 0. Then when same form opens, get this property and do a select case, one case for every tab.

[June7]

My preference would be for a normal form with normal command buttons.

[bilalo]

You can use the navigation control selectedtab properties: caption or name. Name is probably cryptic value; caption probably more intuitive to you.

Forms![navigation form].NavigationControl0.SelectedTab.Caption

assumes you kept the default name for the nav form (navigation form) and default for control, which may or may not end in 0. Then when same form opens, get this property and do a select case, one case for every tab.

Thank you, that's what I was looking for