>>>>>>The situation is like this. I have a form with a parent-child
>>>>>>table. The child table is shown in the grid. When the user wants
>>>>>>to add a record, I change the control source of the parent table to the memory fields.(I am using
>>>>>>table buffering ).
>>>>>
>>>>>Alarm bells are going off in my head when I read this line. Why do you need to change
>>>>>any control sources? Why are you using memory fields and Table Buffering? If you're
>>>>>using buffering, you should be able to work directly with the table fields, and Fox
>>>>>will handle whether they're in memory or on disk.....
>>>>
>>>>Bells have broken loose in my head. The problem is I am too afraid to try on the table buffering to handle everything
>>>>I tried it once and I was gettig strange results and after that I never tried. The main problem is the primary key
>>>>validation. I accept the view of surrogate keys but the users want a sort of their own key and it has to be
>>>>also unique. In my experiment with buffering, I was not able to validate the fields before the user leaves the
>>>>control. Somehow I dont understand how all of you are using it. May be I am too dumb to understand.
>>>>
>>>>Thanks for the reply.
>>>>
>>>>alex
>>>
>>>Alex,
>>>If your VALID returns .F. no one is going anywhere.
>>>You can also return a number to get you where you want.
>>>Using This.Value for your validation rules is fine.
>>
>>Thanks. I did it once and I got into big problems. I was not able to come out of the valid without injury.
>>Thank you very much.
>>
>>alex
>
>Now that you mention it I had some problems calling another form from within a grid's ,textbox's VALID.
>I ended up putting the validation in the lost focus and using the GETFLDSTATE() and
>SETFLDSTATE() to trigger validation. This was a problem with both 3.0 and 5.0. ;
>however, I just got the Visual Studio service pack 3 and did a quick test using the same in a valid
>and it worked. I haven't checked it out in detail yet. I don't know if this really applies to your
>situation but I know what you mean about problems in the VALID.

Thank you for the tip. I am yet to download the service pack. I have big problems with downloads. The ISP
is not very reliable.
thanks
alex