>The only problem is this closes the form or formset. I woul like to return them to the form to correct the data without having to start all over
You expect the user to enter the data in a form. This form has a command button with code in it to check if the user has entered the right data. If the data is not as desired, then your could have a variable that returns .F. And in the if statement, you could clear the textboes with incorrect data, and set foucs to that control. Then you can for example, disable the Save button, if you don;t want to save the user.
If however, the data itself is entered on a different form, then you could validate the user's data and if not valid, call the other form. e.g
if data is not correct
do form <name of the form>
else
do whatever you need to let the user progress
endif
I hope I am correct in my interpretation of what you are trying to accomplish.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons