Submit to DB, Open New with current values

L

Luke Slotwinski

Using Infopath 2003, JScript:
I have designed a form that submits to MS Access DB.
I have a button, Submit, which submits all data and clears the form
(Infopath functionality, works fine).
I would like another button which will submit all data, and clear only
certain of the fields (primary key included), leaving the others as they are.
I tried to code a XDocument.Submit() and then line by line setting the
fields to "". That didnt work, it did the inital submit, and cleared the
selected fields but on the next submit it updated the previous record rather
than making new one.

I'm thinking I have to call a new form and call those values in somehow...
Any help would be greatly appreciated.

Thanks,
Luke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After Submit Clear Specified Fields Only 1
Submit form then carry values over to new form 0
How to Submit rows of a repeating table to a SharePoint list 1
error: The form cannot be submitted because of an error. 0
Non Admin User Error on People field 0
VBA Scripts Word 2016 4
Submit Form Button 0
Default required fields message on submit 1

Top