Command line to update records

[Richard B]

Hello

I have subform, when I click on an item in a list box, it will filter the subform with the necessary records.



In the subform, there is a Yes/no field where I can check/uncheck for records to export. There is also a command button that updates all the check boxes to true if I wish check all the records. The code behind the check all button loops through the recordset and updates accordingly. It is abit slow and was trying out a update command to speed things up but was not able to do it.

How do we write an update command for a "subform/recordset clone"?

Thank you in advance for your help.

Regards
Richard

[Missinglinq]

Not my forte, but maybe a SQL Update Statement will be faster. Something like this:

CurrentDb.Execute "UPDATE NameOfTable SET NameOfTable.YesNoField = -1", dbFailOnError

Linq ;0)>

[Richard B]

Thanks for taking time to help

[Missinglinq]

That's why we're here!

Welcome to the forum!

Linq ;0)>