 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / January 2008After Submit Clear Specified Fields Only
Using Infopath 2003 and JScript I have built a form which submits to a MS Access DB. I added two buttons: submit1 and submit2 submit1 works properly, it submits to DB and clears form. submit2 i am trying to get to submit to DB and clear only specified fields leaving others as defined before submit2 was triggered. I tried to use XDocument.Submit() and then manually setting each field to "" via DOM SelectSingleNode. What happends is that submit2 clears the fields properly but then the next submit doesnt create a new row entry rather it updates the first entry. Basically I'm seeking to submit to DB then carry over certain values to a new form. Thanks in advance, Luke Slotwinski Hi, Are you using any field as Primary key in the table? If you are using any field in the form as primary key, then refresh that field also when you click on the “Submit2” button. So you can create the new row. I hope this will help you.  SignatureAnuma Reddy http://www.GGKtech.com > Using Infopath 2003 and JScript > [quoted text clipped - 10 lines] > new form. Thanks in advance, > Luke Slotwinski |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.