Errorcode 2108

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

Hi,

I try to update some fields in a form using a recordset I get by the
recordsetClone method. When I try to get the focus for a field by setFocus I
get the errorcode 2108. I try to tanslate the message (I get it in German)
You have to save the Field first, before yo can use the GoToContol- or
SetFocus-Method.
It doesn't matter, if the Field is bound or unbound.

This is the code I use:

Private Sub Refresch_UF_Ver4SST()
On Error GoTo ERR_Refresch_UF_Ver4SST
Dim rst As Recordset, intI As Integer
Dim fld As Field
Dim WertStr As String
Set rst = Me.RecordsetClone

intI = 0
rst.MoveFirst
Do While intI < rst.RecordCount
Debug.Print intI
KF_Rolle.Undo
KF_Rolle.SetFocus
KF_Rolle.value = rst("R_Name")
Debug.Print KF_Rolle.value

rst.MoveNext
intI = intI + 1
Loop

Exit Sub
ERR_Refresch_UF_Ver4SST:

Debug.Print Err.Number
Debug.Print Err.Description

End Sub


Maybe somebody can help me. Many thanks.

Mark
 
Mark,

I'm not clear on what you are trying to do here... it looks as though
you are trying to set a new value in a form control based on the value
of a field in its recordset? Why involve the form in updating a
recordset? I suspect you are somewhat confused with recordset
operations. Can you explain in plain english what you are trying to achieve?

Nikos
 
Back
Top