I have a form whose record source is a query and it is filtered by a Primary Key. I'm using an UPDATE SQL statement to add information to a field (can't do it directly as the query won't allow edits (Totals are on).

When I .requery the form, the filter goes away and other data appears. Is there a way around this?

Adding:
        Forms!ChitListF.Filter = "[EvDtID] = " & Forms!ChitListF.EvDtIDtxt
        Forms!ChitListF.FilterOn = True

doesn't work.