InfoPath Dev

I am using IP 2003 tied to a database

I have a new form that collects 2 data elements and upon submit, the 2 
fields go to the database.  That works well.

Because the form will get used throughout the day, rather than close the 
from, I just set the 2 values to blank after the database submission and 
leave the form open.

However, when the user submits a new request, the data is not going to the 
database table.  No error message - just the data never gets submitted.

Am I missing something simple as a way to keep the form open but clear the 
fields and accept a second submission?

Thanks

Art

Typically to reset a database type form I would put in an invalid query value. Such as an id value of 99999 or something and then query the main data connection.

This resets so you can submit again.

This also allows all of the data fields to be reset in one action instead of the fields individually.

I do not understand

Do you have a query that is not seen by the end user running on submit?

Yes, exactly.
Your submit should be via rules
first action submit main
2nd set query field
3rd  query main

This would be how to submit and reset automatically in one click by the user.
All they will see is the form reset and a confirmation of the submit.