467,181 Members | 1,074 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,181 developers. It's quick & easy.

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.
Oct 14 '09 #1
  • viewed: 9669
9 Replies
Expert Mod 16PB
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.
Oct 15 '09 #2
Has there been any resolution to this issue?

Oct 26 '09 #3
Expert Mod 16PB
Nothing confirmed. Why do you ask (The answer seems fairly obvious)?
Oct 26 '09 #4
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.

Oct 26 '09 #5
Expert Mod 16PB
No sorry.

I would need to see the items concerned even to know where to look if it's not the .AllowFilter property..
Oct 26 '09 #6
Expert 256MB
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.
Oct 27 '09 #7
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.

Oct 27 '09 #8
Megalog - this is ancient history for you now, but I just encountered this problem in an Access 2007 split form. After searching far and wide your suggestion was the only one I found that made any sense for my situation. I do have a complex SQL string in the form's RecordSource so creating a new query and referencing that was spot on. All the quick filters are there now! Thanks.
Sep 19 '14 #9
- Hi... this was exactly the issue: the "Data Source" of the form had an SQL string instead of a query. This was preventing the display of the quick filter option. I replaced the string for a query and it did the trick. Thank you very much for the tip, saved me a lot of time.
Oct 17 '19 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Robert Neville | last post: by
reply views Thread by CSDunn | last post: by
1 post views Thread by Jay | last post: by
7 posts views Thread by Mike | last post: by
23 posts views Thread by Dave G @ K2 | last post: by
8 posts views Thread by Abedin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.