<div>
recordset.update will use the fields collection actual vs retrieved values, so, it will rather work like this:<br />
<br />
recordset.fields(&quot;field&quot;).<wbr />value = &quot;value&quot;<br />
...<br />
recordset.update<br />
<br />
and adodb will generate and run the sql for you.<br />
<br />
if fields and values are 2 collections/array/... you &quot;just&quot; need to loop through them and make the line to assign the value &quot;dynamic&quot;...
</div>


recordset.update will use the fields collection actual vs retrieved values, so, it will rather work like this:

recordset.fields("field").value = "value"
...
recordset.update

and adodb will generate and run the sql for you.

if fields and values are 2 collections/array/... you "just" need to loop through them and make the line to assign the value "dynamic"...

<div>
Dim strFile As String<br />
Dim varValue As Variant<br />
<br />
'set your field and value variables ...<br />
<br />
'then pass them in like this ...<br />
rst.Fields(strField).Value<wbr /> = varValue<br />
rst.Update<br />
<br />
Steve
</div>


Dim strFile As String
Dim varValue As Variant

'set your field and value variables ...

'then pass them in like this ...
rst.Fields(strField).Value = varValue
rst.Update

Steve

<div>
<div class="content wysiwyg-content">
I want to use ADODB.RECORDSET 's UPDATE method but I need to use variable in the FIELDS AND VALUES argument.<br />
&nbsp; 'recordset.update fields,values
</div>
</div>


I want to use ADODB.RECORDSET 's UPDATE method but I need to use variable in the FIELDS AND VALUES argument.
  'recordset.update fields,values

syntax of ADODB.recordset's UPDATE with variable used in FIELD and VALUE argument?

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.