Re: keyword search

From: Rick (anonymous_at_discussions.microsoft.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 15:23:21 -0600

I would put a 'search' button next to each of the fields that would be
searchable. When clicked, I would have a msg box come up and ask for the
string to search for. I would then apply a filter to the form based on that
string.

I'd also have a button on my form to 'remove filter' or 'show all'.

"Chrisx" <anonymous@discussions.microsoft.com> wrote in message
news:11c4801c3f590$79505770$a001280a@phx.gbl...
> My boss would like my form to have search capability
> where she could select a field that she wants to search,
> enter a keyword and get the record(s) that meet the
> criteria.
> We have a database that keeps track of courses
> offered. There is the course name as well as a
> description of the course.
>
> As an example, she wants to be able to select course
> name or description and search for any occurrence of the
> word "C++". If course name was selected it would return
> courses where C ++ was in the course name, like "Intro to
> C++", "Advanced C++ Topics", etc.
> If description was chosen, it would return courses
> that had descriptions like "This class is a pre-requisite
> for C++", "Builds on fundamentals from Intro to C++", etc.
>
> Would it be like 2 combo boxes, 1 to select the field
> to check (course name, description) and another to enter
> the string to search for? Can this be done?
>
> If I didn't explain this clear enough, please let me
> know. Thanks for the help.