I think this has been answered here but for newer versions of InfoPath.
Designing a form using InfoPath 2007 and Access 2007. An Access query is the secondary datasource for a drop-down box.
Output is just an XML file. Plain forms, not browser-enabled.
By drop-down works fine unfiltered (but I have a lot of entries). I want to filter ...