InfoPath 2003 Query returning no values
Posted on 2011-03-09
I have created a form that uses the customer number in a query field to return customer and equipment data. The data resides in a 2003 access database table named "Customers." When I previewed the form the first time I had no problem populating data. The second time I tried it I recieved an error message stating no query data was found. Not True, data exists.
I deleted the data link, recreated it, restablished my bindings and tried again with no luck. I then copied the SQL statement from InfoPath and pasted it into excel and tried to pull up the data with success.
I'm stumped now. I've looked at the forms permissions and nothing has changed since I created it.
Any ideas on what to check next?