Filter a query

[Guest]

Maybe you can help me out. I have a query and I want to be able to use my
"Filter by Form" button to sort out the project that I want to work on, but
when I go into the "filter by Form" to sort out a particular client or
project, it only read "Null" or "Not Null". How do I add values? Please
advise.

Thanks!
T.

 

[[MVP] S.Clark]

I honestly don't think people use this feature, but the basis is that the
combobox should be populated with all of the values contained within that
column from the table. So, is that column bound to a field in the table is
probably the first question you should persue.

 

[Guest]

Ok, how do make the combo box populate. My coworkers are used to using excel
and I think that this is a great way to help them in the transition since
they have become accustomed to using the auto filter in Excel and this is the
closest that I can find to it. This has been a task for me also, because I’ve
learned how to use Access a few years ago in the Millennium ME version and
not only am I bit a rusty, but the version that this office uses is 2000. So,
if you have other suggestions for me, please let me know.

Thanks!
T.

 

[John Spencer (MVP)]

How many records are involved?

There is a cutoff number that is set.

Try looking under Tools: Options: Edit/Find and set the Don't Display lists ...
to a higher number. Make sure it is less than 32766 as that is the maximum
number that can be set (at least in Access 97)

 

[Guest]

Thanks! That is exactly what I was looking for.

T.