I am building a screen that uses text boxes and combo boxes above a data grid to enter/edit detail data that will be saved into the datagrid. When I attempt to add a new detail record the blank row correctly shows up in the data grid and when I save the record it shows in the data grid, but the SQL table does not get updated. When I move off the header record and back on it, the added detail record does not show. If I manually set focus on the newly added row in the data grid after the row is added, enter data into the text boxes, and save, the detail record saves properly to the SQL table.

Based on this behavior, what I need to do is set the focus on a cell on the new record in the data grid with code, but I don't see how to call that object(the cell of the grid). Does an array need to be set up that defines the cells. If so how do I do it? Will it incorporate the new row?

The only other option I see is to allow the user to modify the data in the grid itself, but I would prefer that the key entry be done outside of the grid to minimize keystroke errors.

Thanks in advance for your help