I have a form in my application which selects data from th backend SQL server and brings it into a grid

This is the code I use to get the data

    Dim sSQL As String
    sSQL = "Select * from V_FundAllocation where projectID = " & gURN
    cnn.CursorLocation = adUseClient
    Set grd_FundAllocation.DataSource = GetRecordset(sSQL)

This is working fine

however, even though the datagrid property AllowUpdate is set to true, when I change a value in my datagrid, this is not saved back to SQL.

I tried out

with FundAllocation.datasource
.update
endwith

but this is not right, can anyone tell me th correct way to update the changes in the grid.

Many Thanks