M
MHenry
Hi,
I use many forms in Access 2000, and in many cases apply filters.
Dozens, perhaps hundreds of them work just fine, but in a few forms,
the filter criteria is cleared after each use. This never happens in
the other forms. The problem forms have two subforms.
That is, I enter the filter criteria as below*, apply the filter, save
the form, close the form, come back to the form later, and the filter
criteria is cleared.
I must reenter the filter field and criteria again to make it work.
I run Windows 2000 on a Pentium 4, 2.4 GH, 17 gigs free hard drive
space, 512 MB RAM
What other information should I supply to get help on this issue?
Thanks,
MHenry
*Advanced Filter/Sort
1. Open a form in Form view, or a table, a query, or a form in
Datasheet view.
2. Click in the form, the subform, the datasheet, or the subdatasheet
that you want to filter.
3. On the Records menu, point to Filter, and then click Advanced
Filter/Sort.
4. Add the fields that you need to specify the values or the other
criteria that the filter will use to find records to the design grid.
5. To specify a sort order, click in the Sort cell for a field, click
the arrow, and then select a sort order. Microsoft Access first sorts
the leftmost field in the design grid, and then it sorts the next
field to the right, and so on.
6. In the Criteria cell for the fields that you have included, enter
the value that you are looking for or enter an expression.
7. On the Filter menu, click Apply Filter to view the filter's
results.
I use many forms in Access 2000, and in many cases apply filters.
Dozens, perhaps hundreds of them work just fine, but in a few forms,
the filter criteria is cleared after each use. This never happens in
the other forms. The problem forms have two subforms.
That is, I enter the filter criteria as below*, apply the filter, save
the form, close the form, come back to the form later, and the filter
criteria is cleared.
I must reenter the filter field and criteria again to make it work.
I run Windows 2000 on a Pentium 4, 2.4 GH, 17 gigs free hard drive
space, 512 MB RAM
What other information should I supply to get help on this issue?
Thanks,
MHenry
*Advanced Filter/Sort
1. Open a form in Form view, or a table, a query, or a form in
Datasheet view.
2. Click in the form, the subform, the datasheet, or the subdatasheet
that you want to filter.
3. On the Records menu, point to Filter, and then click Advanced
Filter/Sort.
4. Add the fields that you need to specify the values or the other
criteria that the filter will use to find records to the design grid.
5. To specify a sort order, click in the Sort cell for a field, click
the arrow, and then select a sort order. Microsoft Access first sorts
the leftmost field in the design grid, and then it sorts the next
field to the right, and so on.
6. In the Criteria cell for the fields that you have included, enter
the value that you are looking for or enter an expression.
7. On the Filter menu, click Apply Filter to view the filter's
results.