I have an InfoPath form connected to a SQL database. I have two fields in the Query window for the user to choose from in retrieving records. Previously I had three fields, but it was decided that the user did not ever query on the third field. When I try and query with the new form on just the two fields, I get an error stating that there are no records. I know that there is a record based on those 2 fields. When I go back and use an older version of the InfoPath form and enter just the two fields, the record is returned.
What have I not done properly in modifying the form to only have the two fields to query on?
Any and all help would be greatly appreciated.