Navigation Buttons on Forms

[CrazyAccessProgrammer]

Access 2007, Fully Patched as of 02/06/2009

I have a popup form opening from it's parent form which opens filtered based
on the parent form's current record.

The popup form's Navigation Buttons property is set to YES which is what I
want. However, I don't want user's being able to unfilter the form by
clicking the FILTER button on the Navigation Buttons bar.

Is there a way to have the Navigation Buttons appear on the form without the
Filter button or is there a way to disable the filter button?

 

[Rick Brandt]

Access 2007, Fully Patched as of 02/06/2009

I have a popup form opening from it's parent form which opens filtered
based on the parent form's current record.

The popup form's Navigation Buttons property is set to YES which is what
I want. However, I don't want user's being able to unfilter the form by
clicking the FILTER button on the Navigation Buttons bar.

Is there a way to have the Navigation Buttons appear on the form without
the Filter button or is there a way to disable the filter button?

You could change the RecordSource of the popup to a query that returns
the desired rows instead of using a filter. Then there is no filter for
the user to remove. An easy way would be to have the popup form's query
reference the parent form in its WHERE clause.

 

[CrazyAccessProgrammer]

I'm trying to avoid referencing anything from the parent form as this
particular popup form can be accessed from multiple forms.

It can obviously be accessed from the parent form. But it can also be
accessed from other forms that reference a record from the parent form.