On my form, users enter data in to text boxes. When they
push the "submit" button, the macro runs a few edits. If
it passes the edits, everything is okay and the form
closes.

If it doesn't pass the edit, I would like the form to stay
visible / open / etc. so the user can enter / correct
data, so it will pass the edits.

However, the form is no longer visible and the user cannot
update the data.

Any suggestions would be appreciated. Thanks for all of
the help with this..............

Hi,

check for occurance of "End" somewhere in the macro text,
Call hide in the Clickevent only if macro was successfull

"JT" wrote:

On my form, users enter data in to text boxes. When they
push the "submit" button, the macro runs a few edits. If
it passes the edits, everything is okay and the form
closes.

If it doesn't pass the edit, I would like the form to stay
visible / open / etc. so the user can enter / correct
data, so it will pass the edits.

However, the form is no longer visible and the user cannot
update the data.

Any suggestions would be appreciated. Thanks for all of
the help with this..............

You must be hiding or unloading the form somewhere. Just find that and
intercept it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JT" wrote in message
...
On my form, users enter data in to text boxes. When they
push the "submit" button, the macro runs a few edits. If
it passes the edits, everything is okay and the form
closes.

If it doesn't pass the edit, I would like the form to stay
visible / open / etc. so the user can enter / correct
data, so it will pass the edits.

However, the form is no longer visible and the user cannot
update the data.

Any suggestions would be appreciated. Thanks for all of
the help with this..............