Problem with the quick Filter function on database tables

[Cackle61]

My DB has several tables and for most of the fields, the filtering works fine, including clearing the filter and re-filtering options. However there are several fields for which it doesn't work properly. e.g. refer to the images attached to the next post:
1) pre filtering .jpg - I filter the field for one value on the list. It filters OK, but;
2) post filtering.jpg - all other values are removed from the checkbox list, the and the "Clear filter" option is not available and the funnel icon is not present in the title bar.
I've compared configurations for all the ones that don't work properly with each other and with some that do. There are no settings unique to the problem.
Also, I cannot see any relevant settings in the File>Options menu.
Does anyone have any tips?
Thanks

[Cackle61]

the attached images may help with understanding the problem.

[imgnothumb]http://bytes.com/attachment.php? attachmentid=76 28[/imgnothumb]
[imgnothumb]http://bytes.com/attachment.php? attachmentid=76 29[/imgnothumb]

[zmbd]

You also need to include the code:
Please, click on the [CODE/] button in the post toolbar and then cut and paste your script between the [CODE] [/CODE] tags.

[Cackle61]

There isn't any code.

[zmbd]

Looking at you pictures in post#2

The first image is the ORIGINAL table and data

The second image is of the SAME table and data, just after the filter has been applied?

Operating System?
Version of Access/Office?
If ACC/OFF2010 or newer, and a supporting OS, 32bit or 64bit install?
Have you installed all of the updates to BOTH the OS and Acc/Off?
Once installed, you should COLD boot the PC. If you haven't cold booted the PC since you've installed updates, please do so now and the try the filters again.

[Cackle61]

You are correct in your interpretation of the images.
OS = Win7, 32bit
Office version = 2010
All updates have been applied and system rebooted.
The problem persists.

[zmbd]

1) Make a backup copy of the database file.
2)though it might not be the root cause,
duplicate a table that you are having this issue.
Then remove all non-alphanumerics and spaces from the field names.
-alphanumeric:
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access
3) Perform a compact and repair on the database
3a) close both the file AND access afterwards.
4) reopen the compacted file.
5) in the duplicated table and the original, see if the prolem persists.

[Cackle61]

Thanks for the suggestion. Unfortunately the problem persists.

[zmbd]

Are you in a "split form"?

[Cackle61]

What do you mean by "split form"?

[zmbd]

A split form is a "special access database object" introduced in ACC2007 that is a combination of a single record view and datasheet view of the same record source: Access 2007 Create a split form
IN the past to create something like this took a fairly advanced understanding of VBA, form, and database design. MS version of this form does some weird stuff and is the only object that I've known of to have an issue such as you're experiencing with the quick filters...

I've been unable to recreate the situation you're experiencing using either straight queries, tables, or forms based on these record sources.

To make matters more interesting, outside of the split form, I do not see this issue floating around the webs either, nothing in the MS-KB articles - so a real head scratcher.

Do you have another PC/Mac-Office install that you can take the file to and open it from there, it may be something with the installation or conflicting programs.

I am guessing that the data is still actually there... i.e. this bug occurs, you close the database reopen and the data is still in the table and the filters clear, yes?

[Cackle61]

OK, thanks. I'll look into it.

The answer to your last question is "yes". In fact, I can 'undo' the filter and the complete list returns. No data is actually lost, just hidden from view.

[Cackle61]

I have established that it is not a split form (none of the database's tables is). They're all just plain-old tables.

I've tried the db on other machines with both Office 2007 & office 2010. The problem is still there.

[zmbd]

I've tried the db on other machines with both Office 2007 & office 2010. The problem is still there

I take this to mean that you have two different versions of Access opening and closing the same file? This has been known to corrupt the database files resulting in undocumented errors.

Each Version of Access should either have its own copy of the file that you somehow manage to merge data from or ideally each user has their own copy of the front-end portion of the database.

[Cackle61]

That's how we run it. The back end is stored on a server location. Each user has his own copy of the front end/UI.

some of the users are still on Office 2007, so any updates to the UI, I have to do twice - once for 2010 on my PC and once for 2007 on another PC, because of other problems.

I'm pretty sure the back end was created on a 2007 installation, but the current problem occurs when the back end is opened on either a 2007 or 2010 machine.