I try again:
I'm trying with a simple form where
there are just a couple of fields with dataSource, dataMember and DataField correctly binded to the only dataenviroment and the one and only RecordSet.
As i run the application i see the data correctly displayed
on all the edit controls; BtnNext and BtnPrevious are working correctly and data on edit controls is syncronized with the current record.
The problem arise as i change the filter and requery, as in
BtnSearch_Click and BtnRemoveFilter_Click().
After a call to one of this function, the edit controls won't get anymore updated, they just show the value of the last displayed record. Debuggin BtnNext_Click and BtnPrevious_Click i see that the cursor inside the recordset is moving correctly, the current record change, but the auto update of the edit controls doesn't work anymore.
sorry i was long.
any kind of help would be very very very appriciated.
Masi
Private Sub BtnPrevious_Click()
DataEnvironment1.rsSelAg.MovePrevious
End Sub
Private Sub BtnNext_Click()
DataEnvironment1.rsSelAg.MoveNext
End Sub
Private Sub BtnSearch_Click()
With DataEnvironment1.rsSelAgenzie
.Filter = "id_age > 239"
.Requery
End With
End Sub
Private Sub BtnRemoveFilter_Click()
With DataEnvironment1.rsSelAgenzie
.Filter = ""
.Requery
End With
End Sub