I have a parent form whose recordset is based on 3 tables. The tables
have strict one-to-many relationships, and the recordset is
The subform is based on yet another table, with a one-to-many
relationship to the above recordset.
The purpose of this form is to allow users to view records in the
parent form and add a subform record. It all works nicely to this
point. Specifically, the records in the main form correspond to
photos, and the subform identifies the content of the photo. Users
can page through photos and identify the contents with no problems.
What I'm trying to add is a checkbox that can be clicked to filter the
main form. The filter would hide records where the content has
already been identified. I've done this using a left join in the
parent form's record source and that works, or by using an IIF([ID] In
(SELECT...)) field in the recordsource.
The problem with both of these methods is that I lose updateability of
the parent form's recordset as soon as I include those fields. This
is an issue because there is one field in the parent recordset that I
would like the user to be able to edit. Any ideas on how I can get
the filter to work and still have an updateable recordset in the