Dear Experts
I am building a search form to perform a simple search of peoples languages and coverage. The way the database is constructed for this section is as follows:
3 x tables -
tblResearchContact the main table for Peoples details
tbllang Languages spoken, tied up to the peoples ID (done through a look-up & sub form basis)
Tblrescoverage Sectors Covered, as above
There is then a search form [frmsearch] which has 2 combo boxes in it
Combo114 this is the list of Languages
Combo105 this is the list of Sectors Covered
A simple command button brings up a list of people from a query (qryCombinedSearch)
The query queries the whole of the tblResearchContact table & places the selection from the Combo boxes to narrow the results &
tbllang
tbllanguagecoverage
[Forms]![frmsearch]![Combo114]
Tblrescoverage
tblContactsCoverage
[Forms]![frmsearch]![Combo105]
This works fine if I have selected a criteria in both Combo boxes, but doesnt bring up results if one of them is left blank.
Is there a way to adjust the query to ignore a combo box if nothing is entered? For example
EG 1 & Coverage = Equities, Languages = French returns all French speaking people who cover equities
EG 2 & Coverage = Equities, Languages = (blank) returns all equities people regardless of languages spoken (including those who speak no language
Hopefully this makes sense, can anyone help
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.