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
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
