The following is my example code:
Private Sub Form_Load()
Dim myConnection As String
myConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& "C:\MyDatabase.mdb;Persist Security Info=False"
.ConnectionString = myConnection
.CommandType = adCmdUnknown
.RecordSource = "SELECT * FROM MyTable"
Set DataGrid1.DataSource = adodc1
DataGrid.AllowUpdate = True
I can move the cursor go to any cell by using the up & down, and the left & right arrow keys.
However, if I change the cell value, then I can't move the cursor anymore until I push enter.
In Access database, I can move around the cursor by using arrow keys right after I change the cell value. Does anyone know how to modify the above code so that I can move around the cursor by using arrow keys without hitting the enter button?