Hi,
I have created a navigation form where each tab is a different subform but all based on the same table. The first tab contains a subform that is a datasheet of many of the table's fields. The second tab contains a subform that is a regular form; the users will use this form for a certain process. The third and fourth tabs are similarly subforms containing just the fields needed for particular processes. Holy heck it is pretty and the users love it.
My problem is that when you filter any of the tabs (typically the datasheet on the first tab), the other tabs don't follow suit. They are still unfiltered.
Example: Table has 100 records. On datasheet, user filters it for just records of certain date range. Now we're down to just the 15 applicable records. We click on any of the other tabs and they still show the 100 full set.
How can I set the tabs to always have the same filter regardless of which tab I filter the data on?
Many thanks!
Kay
in Toronto