Hi, I have lot of fields in table1, Some of them are combobox source from another table2.
Query is made from table1. Now I want to filter records, successfully filters records which are not comboboxes.
For example:
Table contains field of countries, each country is repeated many times. In query design view > under criteria "France" > then all records are filtered.
But If the same is via combobox field and I do the same > under query criteria > "France" it deos not filter, rather result appears as empty.
What can be the reason? suggestions please. Thanks
Those field which are not sourced via combo, are filtered perfectly.
NOTE: if I remove this filter from combo field, all record appear perfectly, meaning query shows all records, but only does not filter or show blank record, when filter in combo field.
Query is made from table1. Now I want to filter records, successfully filters records which are not comboboxes.
For example:
Table contains field of countries, each country is repeated many times. In query design view > under criteria "France" > then all records are filtered.
But If the same is via combobox field and I do the same > under query criteria > "France" it deos not filter, rather result appears as empty.
What can be the reason? suggestions please. Thanks
NOTE: if I remove this filter from combo field, all record appear perfectly, meaning query shows all records, but only does not filter or show blank record, when filter in combo field.