Filter/Change continuous form with a button

[Ruegen]

I have a form with two buttons that I would like to have change the continuous form that they are on from one of two options.

One button needs to update the view to show performances with feedback where as the other needs to show without when they are clicked.

Any suggestions on how to do this?

[Missinglinq]

Here's some sample code to place behind your Command Buttons; replace all Button Names/Field Names with your actual names:

Private Sub btnWithFeedback_Click()
  Me.Filter = "Not Isnull([Feedback])"
  Me.FilterOn = True
End Sub

Private Sub btnWithoutFeedback_Click()
  Me.Filter = "Isnull([Feedback])"
  Me.FilterOn = True
End Sub

And if you want a button to restore the Form to its Non-Filtered state:

Private Sub btnWithoutFilter_Click()
  Me.Filter = ""
  Me.FilterOn = False
End Sub

Linq ;0)>

[Ruegen]

Here's some sample code to place behind your Command Buttons; replace all Button Names/Field Names with your actual names:

Private Sub btnWithFeedback_Click()
  Me.Filter = "Not Isnull([Feedback])"
  Me.FilterOn = True
End Sub

Private Sub btnWithoutFeedback_Click()
  Me.Filter = "Isnull([Feedback])"
  Me.FilterOn = True
End Sub

And if you want a button to restore the Form to its Non-Filtered state:

Private Sub btnWithoutFilter_Click()
  Me.Filter = ""
  Me.FilterOn = False
End Sub

Linq ;0)>

Thanks - works!

[Missinglinq]

Glad we could help!

Linq ;0)>