I want to have a form with 2 subforms...1 subform would be the parent table...and the 2nd subform would be the child table and they both would be in datasheet view. I want to see all records in the parent table and when I select a different record it would only show me the records in the child table/datasheet that is related. What is the best way of accomplishing this? Any samples out there?
-
-
Hi Alex
The only way I can think of for you to do this would be to have all the records in the child subform and filter it based on records in the parent subform. I think perhaps the On Current event would be appropriate to use.
For more information on filtering forms, check out this insight.
Cascade Form Filtering
Comment