Filter Issue

[thechazm]

So this may be a simple problem to fix or maybe its just the way access works but I have many queries where users can view as reference data. The problem I am facing is that when the user first opens the query they can select the little arrow next to the field and select what they want to filter out. After they do that all of the fields lose their ability to select anymore until they close out and open it again.

Don't know if that makes sense but if anyone has a good idea I am all ears.

Thanks,

TheChazm

 

[boblarson]

Which version (2007 or 2010)?

 

[thechazm]

Version 2007

 

[boblarson]

Do they get this at the bottom? Can they click the yellow area that says FILTERED to start over?

 

[thechazm]

Yes they do have that at the bottom and yes they can clear the filter out but it is only letting them filter one column at any one time instead of letting them filter one column then filter another column to get specific results. I apologies I should have not said they had to close it out every time because that was misleading of what the real issue was.

Actually it looks like when the records returned are at a large number is when the filters start acting funny.

 

[boblarson]

Not sure about it as I've not seen that before. But have you tried binding the query to a form and using the form instead for filtering (in datasheet view). I'm not sure that will have the options available for filtering but if it does, perhaps it might work differently. And, then again, it could be just a limitation on that filtering technique when working with large recordsets.

 

[thechazm]

I believe that it's being limited by the number of rows of data so I'm ok I'll work around it.

Thanks for your time and help.