I am new to Active X controls and I am trying to work with the datarepeater
control. I can populate data into the control, however when I make a change
to any of the controls - it disappears.

Within my datarepeater control, I have 3 textboxes and 3 check boxes. If
I click on any of the checkboxes, the check disappears when I click on the
next row. I tried adding a save button with the following code (but didn't
work):
If (adoExpense.Recordset.BOF) Then
adoExpense.Recordset.MoveNext
adoExpense.Recordset.MovePrevious
Else
adoExpense.Recordset.MovePrevious
adoExpense.Recordset.MoveNext
End If

I'm connecting via ADO control with the following code:
With adoExpense
.RecordSource = "SQL Statement"
.CommandType = adCmdText
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Mode = adModeReadWrite
.Refresh
End With


Can someone pls help and tell me what I'm forgetting as I create this control?
Perhaps I need to add code to an event??

Thanks!