Ok I got further with it now.
Before the user entered values in each of the combo boxes and the text box and then the query searched the specified fields in the table and if there was a match on all fields the results would be displayed.
This wasn't very good because if a user only wanted to do a keyword search leaving the combo boxes blank the search would return null results because each record would have an item from the combo box in the field.
The criteria was this:
[Forms]![search-form]![Combo4]
[Forms]![search-form]![Combo6]
[Forms]![search-form]![Text0]
If you add a little more to the criteria you will be able to carry out a search using any or all of the controllers within the form.
Like this : Like "*" & [Forms]![search-form]![Combo4] & "*"
This is the SQL of the query:
SELECT main_tbl.[First Name], main_tbl.Surname, main_tbl.Company, main_tbl.[Job Title], main_tbl.Question, main_tbl.Answer, main_tbl.Keywords
FROM main_tbl
WHERE (((main_tbl.Surname) Like "*" & [Forms]![search-form]![Combo4] & "*"

AND ((main_tbl.Company) Like "*" & [Forms]![search-form]![Combo6] & "*"

AND ((main_tbl.Keywords) Like "*" & [Forms]![search-form]![Text0] & "*"

);
Hope this helps Tezdread
"With every solution comes a new problem"