I have three grids, all related. For some reason, if I use ThisForm.Refresh() in the 2nd grid's AfterRowColChange() event, the record is locked to the first record in the 2nd grid. If I take ThisForm.Refresh()) out of the 2nd grid's AfterRowColChange event, then none of my textboxes will display anything more than the first record originally displayed when the form initialized.

I want to be able to display the textboxes, which display some of the same data from the table used in the 2nd grid, but cannot do this more than showing the data for the 1st record in the 2nd grid.

Anyone know what I'm talking about?

I believe that I have everything in the relations and the indexes all set properly, but then again, why am I having this problem?

I am ready to leave Grid HELL!