Modifying Datagrid Values 1

[OrWolf]

Hi all,
I have a datagrid that is linked to an Access database. I can pull in the values and update the Access table based on the values entered just fine. My problem is that I want to also be able to update a hidden column to the user's e-mail address to track who is making changes, but I can't seem to find code to allow this. The code I'm looking for should be that if a user updates a cell or row in the datagrid then set the validated field to their e-mail address.

Thank you!

 

[SgtJarrow]

Try:

Me.DataGridView1.CurrentRow.Cells(i).Value = 'Value'

Where i is the index of the datagridviewcolumn you want (remember it is zero-based so the third column is 2) and value is the value you want to set.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer