Filter problem. Removing filter in subform removes mainform/subform link

  • Thread starter Thread starter Jesper F
  • Start date Start date
J

Jesper F

I have a main form with a subform and they are linked with
the the field "ID".
The subform displays the records from a table (tblLetters)
with ID's corresponding to the ID on the main form.

When I use the "Remove filter" command (from right-
clicking or menus) the subform shows ALL the records from
the the table tblLetters. So it overrides the master-child
link.
Is this normal? How can I simple reset the subform to the
starting point showing records corresponding to the main
forms ID? and not all records from tblLetters.

Thanks for any help.
 
There is a bug with Access confusing the Filter property of the main form
and subform, as described at:
http://allenbrowne.com/bug-02.html

Also, if you set the subform's Recordset to an existing recordset, the
MasterLinkFields/ChildLinkFields are messed up.

Unless you have hit one of those issues, the linking should work AFAIK.
 
There is a bug with Access confusing the Filter property
of the main form

Thanks for clearing that up and the link will help me in
the future :-)
 
Back
Top