>I saw a question about this in the archives but threre was no definite solution so I'l ask it again to see if anyone has found an answer.
>
>In a grid in the valid of a textbox I check some data to see if it is ok to proceed - If not I run a form that gives information and returns data including whether or not it is OK to procedd with the input. If it is not I issue a RETURN .F. and sure enought focus stays on the textbox. IF it is OK to proceed I just let the code proceed BUT focus does not leave the textbox. And of course everytime I try to leave the text box the valid fires and focus stays put.
>
>What is the best way to advance to the next column if there are no errors. Keep in mind there may be more than one check in the valid so I have to let all the code execute.
>
>Thanks in advance.
You may try to put several return statements, depending on your conditions (say, in case statement), though it's a not recommended practice. If you return 1, focus should go to the next control, -1 - to the previous, 0 - remain in the textbox. Just try it and then modify your code to use just one return statement.
HTH
If it's not broken, fix it until it is.
My Blog