Filter by form

  • Thread starter Thread starter Vuy Tran
  • Start date Start date
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
 
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 ...
 
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...
 
Back
Top