I have always had a hard time with this. I like using the ColumnCount -1 in grids to automatically populate the grid with Table/View fields, especially when I do all the Caption work in my View.

My question is this, how do I access all the objects of the grid like columns, headers, textboxes, etc. Specifically there are two things I would like to do now. That is, enable the user to doubleclick on a record/row in a grid and "zoom in" on that record. I already have a command button on my form that I use to popup my "zoomrecord" form. I would like to fire the "Click" event of this command button when a record is doubleclicked in the grid.

Also I would like to have the currently selected record highlighted in the grid when I return from my "zoomrecord" form.

I have never been able to figure out how to get to these things in a grid without specifying a specific columncount. Do I have to actually specify a columncount for my grids and manually set them up for each field in each of my seven child tables in order to do what I want to.

Thank You

Elgin Rogers Jr
Epic Solutions