Filter by form shows only "Is Null" and "Is Not Null" value in split database

[jaworski_m]

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

[NTC]

the combobox filter control, being a drop down, must have a record source - - inspect that record source ......

[jaworski_m]

Thank you for reply.
Unfortunately, your answer is not clear to me.

None of the fields (text) on the form I want to "filter by form" is a combobox - text fields only.

As I mentioned in my post, the entire form is based on a query, which behaves in the same way as the form. Once filter by form is chosen only "Is null" and "Is Not Null" are available.

What exactly must be modified (form or query it is based on) to make "filter by form" work correctly?

I would appreciate more detailed explanation.

[NTC]

the pic in your post is pointing to a field that is commonly referred to as a drop down....though in Access this type of control is called a combobox.....it is based on a query - this field/control has its own record source (row source) independent of the form's record source....this is what is generating the options you see and must be inspected......

[jaworski_m]

If properties of the text box (FilterLookUp property) is changed from "Database default" to "Always" the problem is solved.