hi all,
i have a requisition form that gets the ID of the library item to set as part of the filename. when submitting, it queries for the highest ID number, adds 1 to it, then uses that value to set the file name of the submit connection to the library.
when filling out the form, and hitting submit it errors out saying that the list cannot be found. what? it's in its own library...how can the list (library) it came from not be found?
DataAdapterException, Exception Message: The form cannot run the specified query. The list could not be found.
this makes no sense to me. i converted the receive connection to a data connection file, and it works now, but i want to know why i dont have to do this in a different form library.
any ideas are appreciated.