As always, the biggest reason that things work in trace mode and don't elsewhere is the WHILEOPT setting. Make sure you have it set OFF...
Karen > Thanks for all the response I received in regards to my question on > GETDATE. I have the below code in a bit button. > > This code works fine when I trace it in the RBEDITOR but comes up with a > SET error when run on the form. > > The error occurs when I hit the cancel or escape button on the GETDATE > function. > > As you can see, the GETDATE function is nested in the WHILE loop. > > > > >
