Filter by form Listing

  • Thread starter sweyer via AccessMonster.com
  • Start date
S

sweyer via AccessMonster.com

When I filter by form, I cannot drop down a list of values. I only see IS
NULL or IS NOT NULL. There are only 7 records on this table right now, so the
default filter settings do not apply here. I have another form with two
nearly identical fields - FirstName and LastName. For some reason I can drop
down the list of FirstNames, but not the list of LastNames. I've only got a
total of 50 records in the table that form is based off of. Is there any way
I can fix it so that I can drop down all the fields when Filtering by Form.
Thanks!
 
S

sweyer via AccessMonster.com

Nevermind I found the answer on another site. I had to change each field's
Filter Lookup setting from Database Default to Always. Thanks anyway!
 

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 - empty drop down list 3
Form filter combo box choices are Is Null/Is Not Null 3
Filter by form in linked table database 2
Filter by Form problem 2
Form Filter will not delete 2
Show all records 12
Filter by form search field showing non-distinct values in pull do 1
text box filter by form 1

Top