determine new form submission or subsiquent edit

[gurufoo]

MOSS 2007, Infopath 2007, browser enabled forms. No Exchange server,
so hands are tied in some regard. My preference for solutions would be
no-code involved, but I not a code-hater, I just don't know C# or VB
and I'm trying to get this seemingly simple pilot-project off the
ground.

I've got a form library and an Infopath form that submits to that form
library. No problem.

I'm looking to user-proof this form library so my users can't
inadvertenly create duplicate entries when they really intend to edit
an existing entry. What makes sense to me is to *somehow* determine
if the form the user just loaded in their browser is creating a new
entry, or editing an existing entry. I thought I'd be able to bring
in the "Name" or "ID" field, but I can't get that to work. I've
created a Data Connection pointing to the Form Library where the
Infopath Form is submitting to, but it fails to get the data I'm
looking for.

I need to use "Submit" because there is a bunch of validation to be
done. I've disabled the Save As... and similar features in "Tools ->
Form Options -> Browser"

Any help will be greatly appreciated. Greatly.

-James

 

[gurufoo]

Ok, I've found 1/3 of my answer:

In the "Submit Options" of my Submit button, I chose "Perform custom
action using Rules" and added a rule that set a checkbox (to be hidden
later) that essentially says "disable_submit=true". When the an
existing entry is opened up, the submit button is disabled..yay! 8^)
The only toolbars I have on the web form are "Save" and "Close". This
is nearly what I want, but now a user chooses to Save and I lose my
validation that happens upon a true "submit"... I suppose I could
trust my users to not touch anything they're not supposed to
edit....HA HA HA HO HO HEE HEE HEE LOL!!!!!....*wipes tears* sorry,
that was just a funny thought..."trust users...".

*ahem* seriously though, is there a way to get the validation features
of submitting, w/o the risk of creating multiple entries in the Form
Library?

-James