Hi Geoff,
I've seen this behavior. I had a grid on table with a filter set on and I noticed the same problem even without combo. I solved it by placing iif(seek(myKeyField,'MyOtherTable'),MyOtherTable.Description,"") into controlsource or the column, I wanted to show some info. I could not make it work correctly using relationship.
>Hi there
>
>I have a grid that displays data from two tables based on key fields in the table upon which my grid is based
>
>The first column (Work Category) is just used to display and the second contractor uses a combo to display the name of the contractor to assign.
>
>Everything works fine and my data is updated correctly but if I click on the combo and the scroll new data coming into view on the grid displays the same as the last or first line (depending on which way I scroll) on my grid at time I clicked on the combo. Very soon everything looks the same. Hmmm, not good.
>
>If I click somewhere off the grid and then click the grid everything returns to normal and scroll works the way it should.
>
>Any ideas on what could possibly be going wrong.
>
>regards
>Geoff Scott
If it's not broken, fix it until it is.
My Blog