Avatar of jefjar
jefjar
 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?
InfoPath

Avatar of undefined
Last Comment
jefjar

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Clay Fox

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jefjar

ASKER
Creating the new form lead me back to the Database and the query that was being performed there.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes