Search Query

[LordMaximus]

Hi Guys

I'm quite new with Access, so please bear with me.

I want users that access my database to be able to search for records using keywords.

The database is about known issues where people can add the known issue of a certain problem as well as the solution and then later on, to be able to look it up again.

The Data is in a table called INPUT_TABLE and has the fields

PROBLEM
SOLUTION
ENTERED BY

I want to create a FORM which has a text box for "Keyword" , which will then basically have to search the PROBLEM field in INPUT_TABLE.

How do i program that, and also, how can i display the records retrieved. I understand that a query might be easier, but not sure how it works though.

Please help

Thanks

 

[PHV]

Take a look at the Filter and FilterOn properties of the Form object:
In the AfterUpdate event procedure of the keyword textbox
[tt]Me.Filter = "PROBLEM Like '*" & Replace(Me![keyword textbox], "'", "''") & "*'"
Me.FilterOn = True[/tt]

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

 

[LordMaximus]

Sorry PH, but not sure how to do that. Maybe you know of a website that i can read this up on?

I don't know where to add the code and everything else