Hello,
I'm running into a problem where I have a form that people can fill out and submit. That works fine. It's submitting to an Access Db on the back end.
It's a nomination form for an award so people are writing volumes at times.
I've allowed the end user to submit their form but then come back and edit/update to continue and resubmit for as many times as needed.
The issue is, that currently I have the update form hyperlinked to the ID and it's also calling all the form fields. All this information is being passed into the URL and it truncates the data becasue the URL is now WAY too long to accommodate all the data. For the end user, it apppears that they have lost most of what they have written previously even though it's in the database it too much to pull back into the form.
Is there a way to obtain/pass the form field information into an update form without having their data identified in the URL?
I've attempted to link just the ID but it only then pulls the ID over and no other form data.
When I attempted to change it to the field names it seems to resolve still to the data in the field which is again too lenghty for the URL to handle so that didn't seem to do the trick either.
Is there a way I can code it to identify the field name to pull into the udpate form and not have the entire contents of that particular field resolve in the URL?
Any suggestions greatly appreciated!
Shannon