Key word search that produces options 1

[tontenn]

Hi everyone

Once again thanks for every other time I have asked a question, I have received the perfect responses. Now this one has probably been done to death. But I cant find a way in all the searches that accurately and without error does what I want it to do. So I hope someone can help me.

I have a database called "CSCSTD" with fields, ID, Code, FormCode, Title, Description, Updated and Path.

All these items are basic text items but the main two fields im interested in are Title and Description.

What I would like to do is develop a search form so that staff can type in a key word/s e.g. Letter, press submit and a second form or page opens up with the returned links of all the records that contain this key word from title and description.

Then they can just click on the link that they want and it takes them directly to this record.

I know this involves subforms and probably a bit of coding but I'm willing to give it a try to make it work for the business.

Thanks in advance.

Cheers
Tones (From OZ)

 

[PHV]

A starting point:
DoCmd.OpenForm "frmCSCSTD", , , "[Title] & [Description] Like [tt]'*" & [/tt]Me![txtSearchBox][tt] & "*'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tontenn]

Thanks PHV

So I opened my own form and put a text box in it and called it txtSearchBox and then created a button and put an event on the button with code you supplied.

It now says its not working and needs to be debugged and highlights the code you gave me in yellow.

Have I missed a step or do I need to change the code in some way.

Cheers

Tones

 

[PHV]

Any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tontenn]

Hi PHV

No problem anymore. Sorted out the error. I had left in the "frm" in the "frmCSCSTD". I have delted that out and it works amazingly.

Thank you so so much for all of your help once again.

Cheers

Tones