refreshing subforms

[Casey]

Mark,

If the source for your subform is a query and
contains in its criteria for the the fields of it that
relate to your main form, it should always refresh itself.

For example, if the main form is named mainform, and
you have checkbox 1 and checkbox 2 on that main form, and
the subform is named subform, and you have in your query
for subform two checkbox fields such as subcheck1 and
subcheck2 that you use to interrelate to your main form
checkboxes you can place specifications in the criteria of
the query for your subform similar to the following.

In the query for your subform subcheck1 field you
could place: [forms].[mainform].[checkbox1] to relate it
to that checkbox.

In the query for your subform subcheck2 field you
could place: [forms].[mainform].[checkbox2] to relate it
to that checkbox.

That way the checkboxes from your main form would
communicate directly with the fields in your query for the
subform. This only an example and you may use only a part
of the example as a guideline or all of it or more if
needed, depending on your situation.

This may not be the information you needed, but I
know that it is an example of something that would work in
communicating a main form to a subform to keep it queried
constantly.

I hope I helped.

Casey






to your subformwith the filter you now have

contains in its criteria