Form is submitting as soon as field completed.

[Russell]

I have a couple of submission forms which I am using a "submit" button that runs error checking etc... (2 different forms for 2 different tables in the db)

One form is behaving perfectly as I would expect, and after completing the last field recycles back through the <tab> order.

The second form is my problem, if all the fields have text in them - it is autosubmitting and closing the form - and not running the error checking or giving the user a chance to review their input for errors (ie. spelling) before submission.

For the life of me cant see why they are behaving differently.

[June7]

Neither can we. We don't know your data relationships, form design, code. If you want to provide db for analysis, follow instructions at bottom of my post.

[Russell]

Typically.... after pulling my hair out for 2 hours, figured the problem 10 minutes after posting.

The Form behaving "correctly" was "unbound" to the database table - submission only by vba on_click event.
I'd created the second form and bound all the fields - so when they were all complete the submission automatically occurred.

[Welshgasman]

Well that on it's own would not close the form?