[Newbie question] Filter not working on column sourced from the other table

[Ferrugius]

Hello! I've just started learning MS Access and I'm having trouble filtering data in column that sources options from the other table.

I wanted to create a simple search box in split form by using a macro that applies filter to data in specific column. The macro is activated by clicking on a button and sources search phrase from the text box next to it.

This is how it looks like:
[SPOILER]

[/SPOILER]

And this is the condition for the filter (Formularze -> Forms, Tekst82 -> name of the textbox):

[Target name] Like "*" & [Formularze]![Targets]![Tekst82] & "*" Or [Country] Like "*" & [Formularze]![Targets]![Tekst82] & "*" Or [Type] Like "*" & [Formularze]![Targets]![Tekst82] & "*"

Searching works perfectly for "Target name" which has text data type, but it doesn't work (after applying filter no records are shown) for "Country" or "Type" which source available options from other tables.



Could you help me solve this problem?

[NoellaG]

If Country is looked up in another table, the real search value will probably be a long number, not a text. To easily fix this: base your form on a query withon all involved tables and include not only the foreign key columns but also the text value columns of the the linked tables. Then filter on the text value fields, not on the numeric key-fields.
For instance if you have tblCountries ([CountryID] , [CountryName]) include both fields in the query but filter on [CountryName]

[Ferrugius]

It worked! Thank you