[RESOLVED] Selection From a DataGrid.

[gwboolean]

I have a datagrid in which I want to double click on a specific Access record (any cell in the row) and from there open a form that displays the data for that specific record. The subroutine is setup as a double click event for tblFileMasterBaseDataGridView on any cell in the datagrid.
When this event is executed it opens a form as expected. However, I cannot figure out how to open the form to display the specific record selected with the double click. Can anyone describe to me what it is I need to do? Can this even be done?

I have attached the subroutine (with my latest non-working attempt) and the datagrid that I am using to call the form (not in there yet). Sorry that I cannot describe this better, but I have moved way beyond my pay grade on this one.

[Leary222]

to get the selected file ID you need to handle either the cell click or cell content click event

then you can access the e.ColumnIndex and e.RowIndex
using these values you can obtain the file ID as follows replacing 'MyDataGridView' with the name of your datagrid and the 'MyColumnName' with either the number 0 or the column name of your file ID

Me.MyDataGridView.Rows(e.RowIndex).Cells("MyColumnName").Value.ToString

[gwboolean]

It almost worked. However, I get an unhandled exception error on that line telling me that the column cannot be found. And I did use the column in my table not what you put above.

[Leary222]

change to the position of the column, in the image this would be 0 without the speech marks

[gwboolean]

The form opens, but always displays the first record.

[gwboolean]

Actually, it is selecting the column value I want (I put the code into a message box). However, it seems to lose the index when I open the form for that record. Obviously there is something more I need. I have an idea that I am going to try, but let me know if you already know what I am still missing.

[Leary222]

from my understanding of the solution you are looking for:
you want a user to be able to click on a record and for that record to open from the code I have shown you, you should be able to obtain the ID number of the record clicked on and then open the form.

in order to pass that value to the form you can either set a public variable or pass it as a variable in the forms new event.

then what you do with that ID to change what is shown on the form is up to you if you need any help on this please explain further

[gwboolean]

Well that is embarrassing. I forgot that I need to carry the value into the call for the form. And yes, that did give me what I needed, I just seem to have forgotten what I needed.

[Leary222]

no problems hope I have been of help