Active cells in a datagrid.

[colin]

Hi All,

I have a form with a datagrid which displays a number of rows from a database. The data is input using a separate input form.
Could anyone tell me how I could click on a row in the datagrid and that in turn would bring up the selected record in the input form for editing.

Any tips would be appreciated.

Colin

[Orpheus]

Use the DataGrid_DblClick() event to trap a double click in the grid, then determine the selected item within the grid, return the index of the row concerned and then use that to select the data to be displayed on the subsequent form.

Sorry I did not put this into code, but I am on my kids machine and no VB installed to test with before posting.

[colin]

Cheers, i will give that a try.

Colin

[pcabrol]

Colin,

Do you have an exaample of how you connected the DATA grid to show up on your form...I'm trying to actually bring up the data on the data grid..

[colin]

Hi pcabrol,

I'm sorry, not quite sure what you are asking for ? Are you wanting to see how to populate the grid with data or just how to link the grid to a data source or something else.

Let me know

Colin