>>>okay, but the grid definitions is not my problem. My problem at the moment is that I can not get the correct records for the 2nd grid, because contactid is not correct before I even set the 2nd gird recordsource to "". It always stays at the first record for the 1st grid recordsource. It does not move off of it. So my 2nd grid does not change to different records, it always has the same records.
>>
>>Let me try to understand your interface better. Do you move record pointer over parent grid and expect new contents in the child grid? 'Ccract1' is a recordsource for the child grid?
>
>I am not sure about your sentence there. I want to click on a contact in the 1st grid and expect the 2nd grid to show the contents that relate to that contact in the 2nd grid. 'ccract1' is the recordsource for the 2nd grid - child.
>
>Does that make sense?
I agree with Ed. We need just few lines of code to make it to work, there is no need to overcomplicate and introduce some problems.
If it's not broken, fix it until it is.
My Blog