Link to home
Start Free TrialLog in
Avatar of mounty95
mounty95Flag for United States of America

asked on

InfoPath Form Not Returning Records

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.
ASKER CERTIFIED SOLUTION
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mounty95

ASKER

I deleted the field from the query box and I believe that you are right that it is somehow bound and in looking at the underlying queries, I don't see how to unbind that field....
So you pointed me in the right direction.  By deleting the field from the SQL code, saving it as a new form, and then adding the field back as part of the portion of the form that returns data, it, in essence, unbound it.