InfoPath Dev

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 ...

Not sure if the screenshot will be of much help! :)   Whatever is entered into the 'SmearTakerCode' text box, I want to compare with my secondary data source field 'CODE' If 'SmearTakerCode' does NOT appear in 'CODE' for a message to display.  Thanks for any help  

 Hi,  I'm trying to do some validation on a data entry field but can't seem to get it to work! I have a form which is connected to my main SQL data source.  Whithin this form is a Text field which is bound to a field called STCODE.  When the form is compleated the value in the STCODE field is submitted to the ...