A user experienced an issue with a date formatted field that I was able to duplicate consistently.

They were updating a date in this field and accidentally typed the new info in front of the existing data, tabbed thru and the message came up:

Warning:  NEXT CALL cannot be retained with09/1809-17-2005.  Converting to blank.    OK

When you click OK, it freezes the database screen and you cannot manouevre around the form.  The only way to get out is to close the program thru the Task manager, even though it indicates that Sesame is running.

Has anyone experienced this ??

Thanks,

Louis

As a matter of fact, I do as follows:

//WARNS USER THAT NEXT CALL DATE MUST BE GREATER THAN LAST CALL DATE

IF NEXT CALL < LAST CALL THEN
{
     @MSGBOX("", "Date entered is earlier than the LAST CALL DATE.  Please verify !", "")
}

I assume this plays a part in my problem ?

Thanks,

Louis

The programming was associated with On Element Exit.

I placed the code in On Form Exit and tested and it seems to wok fine the way you suggested.

However, it would be nice to keep the user within the record prior to the changes being made.

Is it possible to place programming within restrictions for a field i.e. in the Next Call Date field, placing a >Last Call Date in restrictions ?  I tried this but it didn't work.

Thanks for your input.

Louis

Erika:

Bit by bit, the pieces of the puzzle start to make sense.

Thanks for the reference to the programming coursebook as I have now modified my programming to accomplish what I want as follows:

//CLEAR NOTIFY FLAG

     NotifyForm(0)

//WARNS USER THAT THE NEXT CALL DATE MUST BE GREATER THAN THE LAST CALL DATE

IF @MODIFIED
{
     IF NEXT CALL < LAST CALL THEN
           {
                 NotifyForm(1)
                 @MSGBOX("", "Date entered is earlier than the LAST CALL DATE.  Please verify !", "")
           }
}

Believe me - it's not the DOS environment that's holding me up, it's the lack of programming experience and knowing when to use certain functions & commands that I am trying to improve upon.

Thanks again,

Louis