asked on
InfoPath 2003 Query returning no values
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?
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?
InfoPath
Last Comment
jefjar
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Creating the new form lead me back to the Database and the query that was being performed there.