Filter By Form showing only "IsNull" and "IsNotNull"

[vangogh228]

Hello all!!

The Filter By Form function in my forms and in my underlying tables is showing only the choices "IsNull" and "IsNotNull" except for those fields in which I have lists, like combo boxes. All my table text fields and form text boxes give only those two choices. Aren't I supposed to get dropdowns on every field when I use Filter By Form???

This is a database into which I manually entered no data, but imported 400+ records. Could that be related?

I am supposed to deliver this on Monday, so any help is GREATLY APPRECIATED.

Tom

 

[Travis]

The answer you are looking for is contained in the following MSDN article:

ACC: Filter By Form Options Do Not Apply to Lookup Fields
ID: Q142472

 

[vangogh228]

Travis: Thanks, I'll check that out. At first, I didn't think that was the problem... but I read further on and I think you are right. Thanks again! Tom

 

[Elana]

Tom,

You need to set the filter lookup property of each field to "always."

EB

 

[vangogh228]

TRAVIS:

THAT DID IT... but I have one question. I have only 409 records, and I had to set the number to 10,000 to get my menus. Any ideas?? Thanks!!

Thanks again, Travis.


HI, ELANA!!

 

[vangogh228]

Elana: how does 'always' differ from 'database default?'

 

[vangogh228]

Never Mind!!! I found the help on it.. THANKS!!!!

Another followup: Is there a way to set all my text boxes to ALWAYS without having to select them all individually? I tried "select all" but the property option doesn't show up when I do that.

 

[Pat Hartman]

I hope you're not planning on using this method on a large database. It could take quite a while to populate all those combos.