By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

Null default in a query

P: 2
Created an access database and previously when I did queries each heading in the query offered a drop down of the data previously entered. ie Name etc. It was helpful since as I would spell a name it often would hot key possible results. Now when I do a query under each heading there is no longer a drop down but "is null or is not null. How do I get it back to the way it was. I don't see any changes in properties and if I open an old version of the database, I get the drop down list I want. Sorry about the poor explanation... am new to access. Thanks for anyones help
rwk
Apr 10 '08 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
From the Records menu select Filter / Filter by Form.

This should give you the filtering facility you're after.
Apr 11 '08 #2

P: 2
From the Records menu select Filter / Filter by Form.

This should give you the filtering facility you're after.
Sorry I stated it wrong in the beginning. It is when I "filter by form" that instead of getting a dropdown of all that had been previously entered I now only get "is null", "is not null". In previously saved versions of the database I get the entire list, but now it has changed to is null, is not null.
Thanks
krueg
Apr 16 '08 #3

FishVal
Expert 2.5K+
P: 2,653
Hi, all.

The question was already discussed in "Is Null or Is Not Null? That is the question...

Regards,
Fish
Apr 17 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.