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

"Andre" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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

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é

"Jeanette Cunningham" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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
>
> "Andre" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>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
>
>

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é

"Andre" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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é
>
> "Jeanette Cunningham" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
>> 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
>>
>> "Andre" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>>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 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

"Andre" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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é
>
> "Andre" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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é
>>
>> "Jeanette Cunningham" <(E-Mail Removed)> wrote in message
>> news:#(E-Mail Removed)...
>>> 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
>>>
>>> "Andre" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>>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 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,

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Andre" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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