No selection possible in drobdown list in filter by form on concatenated field

[jaworski_m]

Hello,


I have form based on the following query (there are more fields then one).

SELECT [name] & " " & [lastname] AS Employee
FROM tblEmployees;

When I want to use "Filter by form" on the above concatened field, the dropdown list appears empty.
Is there a way to show list of possible choices or does "Filter by form" work only with a field based on single table field?

Thank you for hints.

[June7]

I've never built a filter by form (I avoid all of the design wizards). If you want to provide db for analysis, follow instructions at bottom of my post.

[jaworski_m]

Please find attached db.
There is only 1 tbl, 1qry, 1 form, but behaviour can be reproduced.

Steps to reproduce:
1. click "Filter by Form" button on the ribbon ("sort and filter" tab)
2."Filter by Form" opens
3. Press dropdownlist of "First and Last Name" field --> empty (why?, is there a workaround?)
4. txtFirst/txtLastName have values to choose from --> OK

Thank you for having a look at the issue.
M.

[June7]

I created a Calculated type field in the table (txtLastFirst), modified query, bound combobox to calculated field, data shows in list in FilterByForm.

So the answer is - must be field from table, not calculated field in query.