Access, keyword, search

Resolved · High Priority · Version 2010

Mon 23 Feb 2015, 12:27 Delegate Simon said...

Simon has attended:
Dreamweaver 8 Introduction course
Access Intermediate course

Access, keyword, search

I'm trying to add a keyword search to my database. Each record can be given up to 6 keywords, each stored in a separate field. I'm using a combo box to produce a dropdown for the parameter query, but it only finds instances stored in the keyword1 field and ignores 2-6. I'm guessing that the combo box dropdown is not passing the selected search word to the criteriea in the "Or" line for keywords 2-6? The expression I am using in each keyword field is [Forms]![Keyworddrop]![Combo0].

Many thanks
Simon

Thu 5 Mar 2015, 14:53 Trainer Jens said...

RE: Access, keyword, search

Hi Simon,

Thank you for the forum question and I am sorry about the late answer.

I have created a database where I have created a form with a combo box. If a keyword is selected and the command button is clicked the query in the database will only show the correct data.

I have attached the database.

I hope this can be a help to do what you want.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector