2007 Forms - Quick Filters not working

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

I created a split form that is based on a query and was hoping that I could
use the Quick Filter option, but it does not display any values with the
respective check boxes, just Sort and Text or Number filters.

There aren't that many records, and some of the fields contain the 2 letter
state codes, surely that should work.

Quick filter do however work just fine if I open the table.

What am I missing here ?

Thanks
 
I just created a split form to test.
The quick filters worked just the same as in the table.

Perhaps you could create a test split form based on a different query - one
that has more records.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Jeanette,
Thanks you for your advise.

I built a new split form on the same query and the quick filters worked. I
am assuming that somehow the first form got corrupted.

Now I just have to port all my fields, code and logic to the new form....

André
 
Magically the Quick Filter Stopped working !

I set the form Allow Edits, Deletes and Adds to No and the filters stopped
working, I also applied a few other changes to some fields (Tab stops etc)

I am going to have to do some testing but so far I have tried to undo all
the changes I made since it worked but can not get working again !

This is frustrating

André
 
I just tested this and here is what I found.

If you set Allow Filters to No, the quick filter is not available.
When you set AlloowFilters back to Yes, the quick filter is available again.

The following settings had no effect on the quick filter:
Setting Allow Additions to No
Setting Allow Edits to No
Setting Allow Deletes to No

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
I have found a few occasions where the quick filters do not work properly if
the control name is not the same as the underlying
field name (particularly combo boxes). Otherwise I agree with Jeanette on
everything she says.

I use split forms and quick filters in everything.

If you just don't see the checkboxes (but still see the filtering options)
that could be due to the number of unique values and the general setting in
Access options. I agree with you that states should work for showing the
checkboxes even with default settings in access options.

Hope some of this helps,
 
Back
Top