<div>
<br />
with me.recordset<br />
&nbsp; &nbsp; &nbsp;.edit<br />
&nbsp; &nbsp; &nbsp;!price=0<br />
&nbsp; &nbsp; &nbsp;.update<br />
end with
</div>



with me.recordset
     .edit
     !price=0
     .update
end with

<div>
you have to run the codes after applying your filter..
</div>


you have to run the codes after applying your filter..

<div>
Thanks, Perfect!<br />
<br />
An elegant solution.<br />
I have never used recordsets before.
</div>


Thanks, Perfect!

An elegant solution.
I have never used recordsets before.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Take a simple table with 5,000 records;<br />
Product<br />
Supplier<br />
Area<br />
Price<br />
<br />
I have a<b> continuous </b>form which display these 4 fields.<br />
I will use the standard &quot;filter&quot; facilities to restrict which records are displayed.<br />
<br />
My Requirement: When I click on a button how do I set the [Price] field to zero for the records that are filtered.<br />
<br />
I guess, the key thing here is how do I process my update on ONLY the <b>filtered</b> records.<br />
<br />

</div>
</div>


Hi,

Take a simple table with 5,000 records;
Product
Supplier
Area
Price

I have a continuous form which display these 4 fields.
I will use the standard "filter" facilities to restrict which records are displayed.

My Requirement: When I click on a button how do I set the [Price] field to zero for the records that are filtered.

I guess, the key thing here is how do I process my update on ONLY the filtered records.



Use VBA to Update All on Filtered Form

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.