Hello,
I split database into FE (forms, queries...) and BE (tables with data) for distribution.
When Filter by Form is active only 2 values are available in combobox filter ("Is Null", "Is Not Null"). All other functionalities of the form work fine (data display).
In the unsplit database Filter by Form works as expected.
All the forms behave like this. See attached file showing behavior in unsplit (filter by form is OK) and split database (filter by form is NOK)
Recordsource for forms are queries.
type of filtered fieleds - TEXT (no memo fields)
What is the reason of this behavior and how can it be fixed so that filter by form works in split database?
Thank you for hints