I have a macro that displays a form with 3 RefEdits. When the user is
finished, they click "ok" and the macro continues. One of the first thing I
do is check to ensure if all 3 RefEdits have data in it. If they don't the
macro sets the focus on the RefEdit that is empty.

I want the form to stay on the screen until all 3 RefEdits are completed.
It stays open and I can enter data but when I push "ok" the second time, the
form goes away and the macro appears to complete but it isnt finishing the
remaining steps.

Any suggestions? Thanks
--
JT

Either there is a userform.hide or there is an error in the code. Use the F9
key to put break points in all functions expecially inside RefEdit Code and
the line in main routine after the userform.show. then determine if an error
is really occuring.

try commenting out all ON ERROR statements to find errors.

"JT" wrote:

I have a macro that displays a form with 3 RefEdits. When the user is
finished, they click "ok" and the macro continues. One of the first thing I
do is check to ensure if all 3 RefEdits have data in it. If they don't the
macro sets the focus on the RefEdit that is empty.

I want the form to stay on the screen until all 3 RefEdits are completed.
It stays open and I can enter data but when I push "ok" the second time, the
form goes away and the macro appears to complete but it isnt finishing the
remaining steps.

Any suggestions? Thanks
--
JT