Multi Field Search 20 - Search Form 2.0 in Microsoft Access


	Back to Search Form 2.0 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multi Field Search 20

Ravi Pillay

4 years ago

All the fields in the search work well, except for the triple state checkbox (Field = IsActive = Number, type = long integer)
The search only shows records that are checked and not the others, for all of the states "Isactive" (blank / nul)
Checked box = -1 in table, unchecked = blank / Nul
I have changed triple state to Yes.
Please Help

	Ravi Pillay OP @Reply 4 years ago

	Teeka Leone @Reply 4 years ago
I have the same issue.

	Scott Axton @Reply 4 years ago
Need more info as to what you are doing/seeing in order to help. Otherwise suggest walking through the video again.

	Ravi Pillay OP @Reply 4 years ago
Hi, my apologies, I was running the Search Form from my Main Menu in which I had a filter "IsActive" = true. I removed the filter from the Main Menu. It works fine now. Thank you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Search Form 2.0.

Next Unseen

New Feature: Comment Live View