I found the following excerpt in another forum posted by somenoe named Miguel. Thought it best described the situation I was having as well. No one has replied as yet, and was wondering if anyne can help me out with this problem:
"I use DoCmd.OpenForm to open a form from another form. To select only the
records tha the user wants to see, I use the WhereCondition property of
the OpenForm. The problem occurs when the user sorts the selected records
using the bottons that Access 2000 has in the tool bar. Then, the criteria
that was specified as WhereCondition is written to the form's ServerFilter
and the criteria in the next DoCmd.OpenForm's WhereCondition is IGNORED.
That is: when there is some criteria in the ServerFilter property of the
form, the criteria you specified in the OpenForm's WhereCondition is not
used by access 2000 and the form opens using the ServerFilter instead.
Of course I know that is normal for Access 2000 to save the criteria in
the ServerFilter property. Wich is incorrect is that the ServerFilter is
applied when the form is open and, even more, instead of the
WhereCondition of the DoCmd.OpenForm.
This problem does not occurs when you use Jet (ie: mdb databases) instead
of Sql Server (project databases). "
Thanks in advance.
"I use DoCmd.OpenForm to open a form from another form. To select only the
records tha the user wants to see, I use the WhereCondition property of
the OpenForm. The problem occurs when the user sorts the selected records
using the bottons that Access 2000 has in the tool bar. Then, the criteria
that was specified as WhereCondition is written to the form's ServerFilter
and the criteria in the next DoCmd.OpenForm's WhereCondition is IGNORED.
That is: when there is some criteria in the ServerFilter property of the
form, the criteria you specified in the OpenForm's WhereCondition is not
used by access 2000 and the form opens using the ServerFilter instead.
Of course I know that is normal for Access 2000 to save the criteria in
the ServerFilter property. Wich is incorrect is that the ServerFilter is
applied when the form is open and, even more, instead of the
WhereCondition of the DoCmd.OpenForm.
This problem does not occurs when you use Jet (ie: mdb databases) instead
of Sql Server (project databases). "
Thanks in advance.