Filtering a drop-down list with conditions - InfoPath Dev Sign in | Join | Help in General InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » General » Filtering a drop-down list with conditions Filtering a drop-down list with conditions Last post 07-23-2015 06:55 AM by jawitthoft. 19 replies. Page 2 of 2 (20 items) < Previous 1 2 Sort Posts: Oldest to newest Newest to oldest Previous Next 07-22-2015 12:31 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Filtering a drop-down list with conditions scrn.png Mark as Not AnswerMark as Answer... Reply Contact The reason I'm suggesting this is so you know exactly what data is being returned to the form. By adding the data fields onto the form and previewing, you can see the values - but the checkbox control could be hiding something... like blank values. Hilary Stoupa 07-22-2015 12:38 PM In reply to jawitthoft Joined on 04-23-2014 Posts 19 Re: Filtering a drop-down list with conditions Mark as Not AnswerMark as Answer... Reply Contact I'm just not too sharp today. I got it now! 07-22-2015 01:03 PM In reply to jawitthoft Joined on 04-23-2014 Posts 19 Re: Filtering a drop-down list with conditions DataScreenshot.png Mark as Not AnswerMark as Answer... Reply Contact Ok, so the data is showing true or false. The Contracts in the screenshot are both showing up in the drop-down when the corresponding vendor is selected. I changed the filter to Not Equal True but no luck. Sorry to be such ignorant on this one. 07-22-2015 02:05 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Filtering a drop-down list with conditions Mark as Not AnswerMark as Answer... Reply Contact Well, I mean - the filter you are using works on the Vendor drop down, right? So I can't really think of any reason why it doesn't work on the contracts dropdown. It really doesn't make sense. Hilary Stoupa 07-23-2015 06:55 AM In reply to jawitthoft Joined on 04-23-2014 Posts 19 Re: Filtering a drop-down list with conditions Filters.PNG Mark as Not AnswerMark as Answer... Reply Contact I'll try one more time or I might just give up. Yes, the filter on the Vendor is working fine. So this is what is in my filters. So the AC25_0016 contract shouldn't show up since it's deactivated and expired. Ughh. Page 2 of 2 (20 items) < Previous 1 2 Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
The reason I'm suggesting this is so you know exactly what data is being returned to the form. By adding the data fields onto the form and previewing, you can see the values - but the checkbox control could be hiding something... like blank values.
I'm just not too sharp today. I got it now!
Ok, so the data is showing true or false. The Contracts in the screenshot are both showing up in the drop-down when the corresponding vendor is selected. I changed the filter to Not Equal True but no luck. Sorry to be such ignorant on this one.
Well, I mean - the filter you are using works on the Vendor drop down, right? So I can't really think of any reason why it doesn't work on the contracts dropdown. It really doesn't make sense.
I'll try one more time or I might just give up. Yes, the filter on the Vendor is working fine. So this is what is in my filters. So the AC25_0016 contract shouldn't show up since it's deactivated and expired. Ughh.