>I have a grid on a form for which I dump in different records from two different tables. I then want the grid to go to the bottom and show the last 7 records and have the 8th row show blank. Using the object I can go to the bottom in the recordsource, but when I do it aligns in the grid to show three blank rows. If I manually click in the grid during runtime and arrow up (to simulate a skip -1 each click) on the grid and count the number of skips and code using the object to do a skip -6 to try to get it to show correctly in the grid the way it did manually, it does not. If I manually click on the little scroll arrow I can get it to show correctly manually every time as well. Is there coding I can use to programmatically to simulate clicking the arrow instead of skiping records in the recordsource? I would like to try that and see if I can get it to position the way I want it. Why do the grids react so much differently programmatically vs in runtime where I can manually move it the same number of times for any given situation and get the display I want?

Check Grid.DoScroll() method.