Private Sub lstClients_Click()
Dim strQuery As String
strQuery = "SELECT * FROM Appointments INNER JOIN AppStatus ON Appointments.StatusID = AppStatus.StatusID
WHERE Appointments.CompID = " & strCompID & "ORDER BY DateTime DESC"
adoAppointments.RecordSource = strQuery
i had using the adodc and data grid to list out different appointments info for the different sales person. i face the problem when i try to update the information (AllowUpdate = True).
the data can be updated successfully if after i update that cells (eg row = 2) and i click the other row (except row = 2)
if i LostFocus from the data grid table (without click the other row) then the value i try to change will set back to the old value. (failed to update)
this situation also make me impossible to update the data if there got jus one row
thanks a lot