Hi
This is a problem I don´t seem to get solved. The problem consists of that I would like to display a query in a form and in the same form I want multiple comboboxes which will work as criteria for a query. I should get it working by putting in following in the Criteria in the Query:
[forms]![SearchForm]![Country] OR ISNULL([forms]![SearchForm]![Country]) and for the other field:[forms]![SearchForm]![City] OR ISNULL([forms]![SearchForm]![City])
This should make it possible to search by Country, City or both - at the same time and the query should show all records over Country OR City OR Both. BUT - the thing is that I have to fill in both comboboxes before the query gives me any info.
I don´t get it to work.
Please help and I´m grateful for all the help I can get
This is a problem I don´t seem to get solved. The problem consists of that I would like to display a query in a form and in the same form I want multiple comboboxes which will work as criteria for a query. I should get it working by putting in following in the Criteria in the Query:
[forms]![SearchForm]![Country] OR ISNULL([forms]![SearchForm]![Country]) and for the other field:[forms]![SearchForm]![City] OR ISNULL([forms]![SearchForm]![City])
This should make it possible to search by Country, City or both - at the same time and the query should show all records over Country OR City OR Both. BUT - the thing is that I have to fill in both comboboxes before the query gives me any info.
I don´t get it to work.
Please help and I´m grateful for all the help I can get
