Navigation Forms and Filters

[Trichmond]

Hope this question makes sense. I am very very new to Access. I am attempting to create a Navigation Form that can be used for Employees Forms, Customer Forms, etc. It is for a graduate school class extra credit assignment.



I have the Navigation Form done. The problem then asks to create a filter button so that only certain employees are displayed based on their PositionID value (1 to 7). When I open and set up the frmEmployeeData (without using the Navigation Form) with the filter using the Access 2010 Macro feature, it works as expected on the frmEmployeeData.

The issue is when I access this same Employee form using the Navigation Form and then select a Filter button, I get the error:

"The action or method is invalid because the form or report isn't bound to a table or query"

I tried to select the object first in the Macro, but then I got a different error about the object not being open. I don't want to open it because then I would be using that object and not the form itself anymore.

My text is fairly vague whether this can be done through the Navigation Form or not. The problem requires I use the Macro feature of Access, not VBA.

[June7]

Review http://social.msdn.microsoft.com/For...a-c4c2a67f39c0

I think key point made in the thread is: when you drop in a form into a Navagtion form, then it becomes "nested" below as a sub form

Referencing subform on a normal form is tricky enough. I haven't used Navigation form so not sure about syntax.

[Trichmond]

Stumbled upon my own solution.

No idea why this worked, but when I used the "Set Filter" Macro command instead of "Apply Filter", it worked fine.