all the data is in tables in access. i have been doing access development since 2000 with over 60 projects. i built this database and then handed it over to the client. They asked for changes and i always keep my emails so i had the history. The sept 1 database worked with the right click and filter by non key field and the subform still showed the records after filter. I have a requery macro that runs on activation of subform and it worked. Then the client emailed me the database on october 1st for some changes and after the right click and filter the subform would not refresh the subform. The macro is stiill the same. My linked fields are still good. My relationships in the queries haven't changed. And my properties all look the same. Why would i be asble to see all the subform records when i open the main form but not after filtering by the rightclick?

thank you again