allow infopath to submit duplicate records

[Rick]

Good afternoon,

I have an infopath form that submits data directly to an access
database. Everything is working fine except for one issue - I want to
allow the user to pull up a previously submitted form, make changes,
and then submit that form to the access database as a new record.
Currently, if the user makes any changes and then submits, access
overrides the previous record with the updated data. I want to
capture each of the changes to the form as a separate record within
the database.

Any ideas? Thanks as always!


Rick

 

[Paresh]

Good afternoon,

I have an infopath form that submits data directly to an access
database.  Everything is working fine except for one issue - I want to
allow the user to pull up a previously submitted form, make changes,
and then submit that form to the access database as a new record.
Currently, if the user makes any changes and then submits, access
overrides the previous record with the updated data.  I want to
capture each of the changes to the form as a separate record within
the database.

Any ideas?  Thanks as always!

Rick

Hi Rick,

Please check the submit logic. I think, you might be updating the
record instead of submitting it as a new record which is why the
existing record(s) is / are getting updated.

Do let me know your views about his, if any.

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh/default.aspx

 

[Rick]

Thanks for the information Paresh,

I've checked my submit button and have not made any changes to the
logic. Could you walk me through what to do to ensure that it is
submitting a new record and not just updating and existing one? I
would greatly appreciate it.

Thank you,


Rick

 

[Paresh]

Thanks for the information Paresh,

I've checked my submit button and have not made any changes to the
logic.  Could you walk me through what to do to ensure that it is
submitting a new record and not just updating and existing one?  I
would greatly appreciate it.

Thank you,

Rick

Do take a look at what rules / dataconnection gets fired when you
click the submit button.
You can check this out by clicking Tools Menu->Submit options

Do let me know if that helps or you need further info.

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh/