I have a form that, when a person goes to the layout, will
automatically generate a unique Form ID. When I created the database,
I chose the 'generate on commit' option.

The question is, do I create a button that would 'commit' this Form ID
(as well as the rest of the fields in the form)? The problem I have
now is that as soon as I click out of another field in the form (i.e.
if I typed in TX in the State field then tabbed to the Country field),
the number generates. Where is generate on commit in that?

Also, then if my user wanted to abort the form before completing it,
as it is now I am stuck with a halfway-completed record that still
shows up in my search results. I have to go manually delete these
records.

Any thoughts?

One way of doing this is creating a dummy layout.
This layout LOOKS ewxactly the same as the main layout
BUT
On this layout are global fields, not the actual fields
When the user is ready he clicks the button.
This runs a script that transferrs all the data from the global fields to
the proper fields. Then it commits the record and the ID is generated. (do
not forget to empty the globals)

Keep well, Ursus

"EP" <ericp023 (AT) gmail (DOT) com> schreef in bericht
news:1173457292.987515.122070 (AT) h3g2000cwc (DOT) googlegroups.com...

I think you are half-way there. You have already set-up your serial
number field to generate "on commit." The next thing you must do is to
set the layout by unchecking "save record changes automaticaly". Go
the "layout setup" and uncheck the option called "save record changes
automaticaly".

Let us know how you get along.

Regards
Kevin