I've used to following to create a form that allows me to navigate though the records contained in my database one at a time.
http://www.bizsupportonline.net/infopath2003/sequential-db-table-record-navigation.htm
Everything works fine but I would also like to add some functionality to be able to search/query the data using a specific field.
After adding the field form within the 'queryFields' and adding a query button when this is run nothing is brought back. I'm guessing it something to do with the filtering from start-up and using the CurrentRecordNumber.
When I hit the query button I presume its only searching whatever number the CurrentRecordNumber is rather than searching the whole database.
How do I add a button that will remove the filtering and bring back all records that match the search criteria of the query fields regardless of the record number?
Any help would be much appreciated