Update Query to Check all Checkboxes in form

[Hamm]

Hi



I am trying to create an update query to check a checkbox for all the records in a form.

The form is created using a query to filter a table and I dont want the update query to check all checkboxes in the table, I only want the records that get filtered into the form to be updated.

When i tried to base the update query on the filter query and run it, it comes up with a message box that says you are about to update zero rows. I assume this is something simple that I am missing.

Any help much appreciated.

Hamm

[June7]

Run an UPDATE query against the table and use the same filter criteria as the form RecordSource.

Post the query SQL statement for analysis.

Review:
https://www.accessforums.net/access/...umn-29629.html

[Hamm]

Hi June7

I can't seem to get it to work. To get to the "Buyers for Final List" form I run a set of sequential queries to filter from the table "Contacts". The last filter is the record source of the form, it is called StatusFilter

here is the SQL i have

UPDATE (([Buyers for Final List] INNER JOIN Contacts ON [Buyers for Final List].ID = Contacts.ID) INNER JOIN StatusFilter ON Contacts.ID = StatusFilter.ID) INNER JOIN TenureFilter ON Contacts.ID = TenureFilter.ID SET TenureFilter.[Use in Report?] = True
WHERE (((TenureFilter.Status) Like IIf([Forms]![Home Screen]![ActiveFilter]=True,"Active") Or (TenureFilter.Status) Like IIf([Forms]![Home Screen]![InactiveFilter]=True,"Inactive") Or (TenureFilter.Status) Like IIf(([Forms]![Home Screen]![InactiveFilter]=False) And ([Forms]![Home Screen]![ActiveFilter]=False),"*")));

[June7]

Why doesn't it work - error message, wrong results, nothing happens?

I am not familiar with your database so no idea why this query doesn't work. Possibly it is not an updatable query because of the table/query joins.