In the error condition, just don't unload or hide the form.

--

HTH

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


"JT" wrote in message
...
On my form, there is a "submit" button. When the user
enters the data, they push the "submit" button.

This kicks off a routine to write the data they entered.
It also has an edit to make sure the amount (one text box)
on the form is not greater than the current balance (of
another field.)

If the amount is less than or equal to the current balance
than there is no problem.

However, if the amount is greater than the current
balance, I do not want to write the data and I want to
leave the form open so the user can make a correct and hit
the "submit" button again.

Not sure how to do this. Should I make the amount vs.
current balance a separate routine within the routine
kicked off by the "submit" button? Any help or examples
would be greatly appreciated.....Thanks for the help.