Quick filter on split form

I have two separate but similar databases and each has a split form that acts as the main form used. One of these split forms is able to be filtered from the datasheet portion of the split form using Quick Filters at the top of each column.
The other database split form doesn't show any Quick Filter values when the column headers are clicked. Does anybody know what the problem is, or where I would change the parameters to enable Quick Filters?
I appreciate any help that anyone can give me. Thanks in advance.

re: Quick filter on split form

I would guess one or other of the form's properties needs to be set to allow filtering. Hang on. I'll check quickly...

I would suggest paying particular attention to the AllowFilter property, but compare both forms for differences and see what allows it to work.

re: Quick filter on split form

Has there been any resolution to this issue?

Leon

re: Quick filter on split form

Nothing confirmed. Why do you ask (The answer seems fairly obvious)?

re: Quick filter on split form

Sorry let me explain: I tried what was posted above, and still cvant get it to work. I was wondering if anyone found the propertu that was causing this problem. I would appreciate any help, thanks.

Leon

re: Quick filter on split form

No sorry.

I would need to see the items concerned even to know where to look if it's not the .AllowFilter property..

re: Quick filter on split form

I've seen this happen a lot on columns using multi-value fields, or if there's a complex SQL string as the form's RecordSource. The filtering option isnt turned off, it's just not returning any of the column values when you click the headers, correct?

If the form's RecordSource is a SQL string, try taking that string and creating a new query with it. Save the query, and set the form's RecordSource to that query instead. Normally it wouldnt change anything, but split forms are very strange and I've found this solution works most of the time.

re: Quick filter on split form

That is correct, its not returning the values. Instead of changing the record source to filter the subform, i used filter functions in my VBA. Seems to work fine now. i appreciate the post.

Leon