Keyword search query (example attached)

[stephenlee]

Hi All,

As shown in the attached database, I have a multiple criteria query with a front end (see frmIssue). I am trying to add a keyword search on the field 'Issue' by having an unbound textbox in frmIssue and linking it with a 'Issue' field in the query 'MyQuery'.

An example search would be looking for an issue with the keyword 'misfiring' in project 'A'.

However, having tried the Like expression on the field 'Issue' a few times, I'm still having trouble making it work. Any suggestions would be greatly appreciated!

Thanks,
Stephen

 

[namliam]

[Equipment type]like "*" & [forms]![frmIssue]![comboEquipmentType] & "*" Or [forms]![frmIssue]![comboEquipmentType] Is Null

What happens to your search if I select project A and equipmenttype Vessel??
Is that desired that I get non??

If you want to try and allow only valid options... Do a search on "cascading combobox" and you will find it...

 

[stephenlee]

cheers, worked a treat!