Hi

That solution would not work for me because I use a generic form to which I add a container containing the controls when the form is activated. The reason for this is that a user can open several forms at once but the controls are not loaded until the form is activated. I think this is called a type for delayed initiation which speeds up the loading of forms.

However, I will keep your solution in mind. This solution makses sense from another perspective. The Controlsource for the column and the control both can reference the Form obect.

Thanks
Simon

>Simon,
>I had the same problem with the ControlSource of columns in grids. I found a solution.
>
>I put the ControlSource as a Method of the form that contained the same Expression. Never had a problem since.
>
>My users typically enter from 20 to 700 hundred entries in one Invoice and they have never had a problem.
>
>Regards
>
>Abdul Ahad
>>Hi
>>
>>I like the idea of grids but my experience several years ago caused me to change to listboxes. The biggest problem I had was that if you used an expression in the ControlSource and the expression was ~220 characters then there were times when this caused the Init events of other controls not to fire (I proved this by running the coverage profile and reviewing the sequence of events when everything work correctly and when it did not). So when the form was displayed there would be controls intermittently missing. I was able to demonstrate this to other developers but I gave up trying to find the exact cause because I was working on a large project that just had to be completed and I was running out of time. As soon as I removed the grids with no other changes to the forms the problem disappeared. Since using ListBoxes I have never had a problem.
>>
>>You may wonder why I used expressions for the ControlSource. The reason was that I wanted descriptions to show in columns where the actual data was an ID of an item from a related table. If I used comboboxes the speed of the grid slowed too much.
>>
>>Expressions occassionally caused the grid to display improperly resulting in the grid elements not being able to receive focus.
>>
>>Another problem was that grids occassionally bleed through pageframes or cause the screen to be scrambled when switching pages.
>>
>>You might argue that these issues are related to the video driver. Perhaps, but I had it happen so many places it was easier to find a solution that did not have these effects.
>>
>>At the time I was using them there was also a bug documented by MS in the Parent/child relationship that would cause the data order in a table to be corrupted.
>>
>>I still occassionally use grid but for very simple things.
>>
>>I solved the editing issue by having the details show to the right of or below the list and it is possible to move up and down the list using navigation keys in the controls in the detail section. So there is no extra clicking to use my solution than there is using a grid.
>>
>>Simon
>>
>>
>>>>>
>>>>>You've heard of MADD "mothers against drinking and driving"
>>>>>we could probably start an organization called VFPPAG "VFP programmers against grids" .... i know a few guys who hate grids as well LOL
>>>>>
>>>>> typically i either do it with a listbox or just say "that cant be done reliably"....
>>>>>but i'll check the .ocx you recommend....
>>>>>
>>>>>thanks for the info.
>>>>
>>>>Then I will start the campaign "VFP programmers for grids!". :) Never had a problem with making the grid to do what I want it to do.
>>>>
>>>>Nick aka "Dr. Grid"
>>>>
>>>
>>>In the one to many form, there are some sitiations in which using the grid makes a lot of sense. Even in the standard scenario in which the grid serves as a locate control, you can use too for data entry when you need fast multiple entries. As an example, lets say the grid holds 20 ordered items and you want to tell the system that 10 of those 20 have been delivered. If you let the field "deliverDate" to be edited in the grid you avoid a lot of mouse clicks and key strokes (if not, the user has to go item by item bringing up the "edit form" and inserting the date).
>>>
>>>I have been using grids for some kinds of data input for many years very succesfuly. I don't share that radicalism against grids for data entry.