DoCmd.GoToRecord,, acNext impossible to pass the record

[sefiroths]

I should make a function with a button that clears the fields on the form.
I wrote this, but it gives me 'a mistake at the first DoCmd.GoToRecord,, acNext
saying before the records were written by many users at once, and then hypoxic switch to the specified record.
that can be?


On Error GoTo Err_Next_Record
[Forms]![Documenti].SetFocus
DoCmd.GoToRecord , , acFirst
Do While (Recordset.AbsolutePosition <= Recordset.RecordCount)
Debug.Print Recordset.AbsolutePosition & " *** " & Recordset.RecordCount
CasellaControllo20.value = 0
CasellaCombinata23.value = Null
quantita.value = Null
status.value = Null
tipo.value = Null
dwgsize.value = Null
[Forms]![Documenti].SetFocus

DoCmd.GoToRecord , , acNext
Loop



Exit_Next_Record:
Exit Sub

Err_Next_Record:
MsgBox Err.Description
Resume Exit_Next_Record

End Sub

[NoellaG]

Hi,

I think you need to work with a RecordsetClone of the forms recordset and then use a bookmark. You can look these up in the help function. Don't forget to handle the possibility of an empty recordset through the properties BOF and EOF.

greetings
NG