updating and filtering for Access nuts

[paulmcdonnell]

Hi guys,

I know how to use a filter to display data in a form.

I use code to update fields a recordset using a DO WHILE.

What I want to do is to update only the filtered records on the form...

Does anyone know how I use the code to update a field only if it was part of the form selection.

(I could use a query for the filter and use this as the record set but I don't want to do it that way on this occasion.)


Cheers

Paul

 

[Rich]

Why not? Either a stored query or any of the SQL methods will perform much quicker.