Filter from header (1 Viewer)

[Rania01]

I'm having a little trouble with the form filter in Access. I'm using the listview in a few forms and the user needs to be able to filter there.
all data is from combo box
please help how to resolve

 

[arnelgp]

On MSAccess, go to File->Options->Current Database
then put 999999999 (nine 9) on:

Don't display lists when more than this number of records is read:

close and re-open your db.

 

[arnelgp]

i don't understand.
i change Recordsource rather than filtering.
test the form again.

 

[Rania01]

Zie result from the filter

 

[arnelgp]

you cannot filter on Long Text, so i change it on tblKlant as Short text.
also there are fields that are Short Text but the content is numeric.
and you are using numeric results from combo, again i change
these fields from Short Text to Long Integer.

see your form.