DataRepeater Update problem

[MikeBronner]

Hi there!

I know, I have seen many posts claiming to solve the issue regarding the problem with the datarepeater not updating the recordsets. I have researched this issue extensively, and am unable to find a solution. Not even the MS [link]http://support.microsoft.com/support/kb/articles/q197/4/28.asp[/url] support page was able to solve this.

I am using ADO in conjunction with the MS Jet OLEDB 4.0 Provider. Then I query the DB with a simple SQL command and read the data into my recordset. After the recordset is opened, I do the following:

drpUserControl.DataSource = adoRecordSet

After loading the form, the datarepeater will display all the data fine, but when i attempt to update the info, the update fails, and the old info is retained. The following is my update code:

Private Sub Form_KeyPress(KayAscii as Integer)
If (KeyAscii = 13) Then 'user hits Enter
On Error Resume Next
adoRecordSet.Move 0 'see MS article above
adoRecordSet.Update
If (Err.Number > 0) Then 'check for errors
'error routine to display
'error message goes here
end if
end if
end sub


Please, please please please help
Thanks a bunch!!

 

[MikeBronner]

I have a suspicion that the cause of the problem may lie within the custom control itself.
I have the get and let functions for each control within my custom control. Is there perhaps anything else I'm missing?

What needs to be added to a custom control, so that it will update its source?

Thanks.

 

[MikeBronner]

i solved the problem: I didn't have the propertychanged subs defined. It's working now!