Unfiltering a subform has problems

J

Janie

If I filter on selection in a subform, when I remove the filter the main form
returns to Record Number 1 and the subform is no longer limited to just the
records associated with the main form.

The main form's records source is a table and the subform's record source is
another table. There is a defined one-to-many relationship between the main
form's record source and the subform's record source.

How can I use filter by selection and the remove the filter and still have
my main form and my subform in synch?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Trouble associating parent form record to subform's record 1
VBA Syntax for subform record source change 6
First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Subform linked to form - ID number to come into subform? 1
Subform is not visible when the main form opens 1
DLookup in Continuous form 0

Top