Have a table named "DownloadFromScanner", need based on some filters (s or r) and (VendorID) to set Yes/No field either to Yes or No.
I made a form "ScannerUpdate) and subform "ScannerUpdateSubform" this subform is based in a query name ScannerUpdate Query".
In the form I have 2 buttons one is named "Yes"and the code is CurrentProject.Connection.Execute "UPDATE [ScannerUpdateQuery] SET [RecordRead]=True".
The other button is named "No" and the code is CurrentProject.Connection.Execute "UPDATE [ScannerUpdateQuery] SET [RecordRead ]=False".
Once I open the Form and subform and applied the filters with the records I want to update I either press yes or no buttons.
Problem is that all the records in the query are updated regardless whether they are in the filter selection or not.