Filter by form

V

Vuy Tran

Have a question that is really confusing me. In an Access
Form, I have multiple fields to contain my data. When I
go and push the "Filter by form" button and click onto a
field in my form, it is supposed to come up with a list of
all of the data to filter from. However, in my form, it
comes up with only two options : "Is null" and "Is not
null". How do you get Access to show all the possible
records to sort from versus only Is / not null?

Thanks,

Vu Tran
 
A

Allen Browne

Go to:
Tools | Options | Edit/Find

Check the boxes under:
Show list of values in ...

If the lookup tables have lots of records, change the value for:
Don't display lists where more than ...
 
G

Guest

Thanks a lot. I will give it a try
-----Original Message-----
Go to:
Tools | Options | Edit/Find

Check the boxes under:
Show list of values in ...

If the lookup tables have lots of records, change the value for:
Don't display lists where more than ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter by form in linked table database 2
Form filter combo box choices are Is Null/Is Not Null 3
Filter by Form problem 2
Form Filter will not delete 2
iif exists - too complex? 1
filtering a form based on a filter on an open form 2
text box filter by form 1
Filter by form Listing 1

Top