<div>
Can I do this with an adodb recordset? &nbsp;When I try this:<br />
<br />
Dim rst As ADODB.Recordset<br />
Set rst = Me.RecordsetClone<br />
<br />
I get a type mismatch error
</div>


Can I do this with an adodb recordset?  When I try this:

Dim rst As ADODB.Recordset
Set rst = Me.RecordsetClone

I get a type mismatch error

<div>
When I try with dao recordset I get the same error as before.
</div>


When I try with dao recordset I get the same error as before.

<div>
Hi again, &nbsp;In fact, it works with the dao recordset. &nbsp;I forget to change the other syntax. &nbsp;I'll accept that solution, but do you know how it could be done with an adodb recordset?
</div>


Hi again,  In fact, it works with the dao recordset.  I forget to change the other syntax.  I'll accept that solution, but do you know how it could be done with an adodb recordset?

<div>
<div class="content wysiwyg-content">
I have the below code in a form's module, which seems pretty basic. &nbsp;But it doesn't work. &nbsp;I get an error message saying, &quot;Run-time error '3020'. Update or CancelUpdate without AddNew or Edit&quot;<br />
<br />
Me.RecordsetClone.MoveFirs<wbr />t<br />
Me.RecordsetClone.MoveLast<wbr /><br />
Do Until Me.RecordsetClone.BOF<br />
&nbsp; &nbsp; Me.RecordsetClone.Fields(&quot;<wbr />DtSubmitEx<wbr />traHours&quot;)<wbr /> = Date<br />
&nbsp; &nbsp; Me.RecordsetClone.Update<br />
&nbsp; &nbsp; Me.RecordsetClone.MovePrev<wbr />ious<br />
Loop<br />
<br />
Is the problem that I cannot update a recordsetclone? &nbsp;<br />
<br />
If this is the case, how can I easily update a field on a continuous form for all the records that are currently displayed? &nbsp;If not, what is wrong?<br />
<br />
Thank you.
</div>
</div>


I have the below code in a form's module, which seems pretty basic.  But it doesn't work.  I get an error message saying, "Run-time error '3020'. Update or CancelUpdate without AddNew or Edit"

Me.RecordsetClone.MoveFirst
Me.RecordsetClone.MoveLast
Do Until Me.RecordsetClone.BOF
    Me.RecordsetClone.Fields("DtSubmitExtraHours") = Date
    Me.RecordsetClone.Update
    Me.RecordsetClone.MovePrevious
Loop

Is the problem that I cannot update a recordsetclone?  

If this is the case, how can I easily update a field on a continuous form for all the records that are currently displayed?  If not, what is wrong?

Thank you.

Can I update a recordsetclone?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.