search form not working properly

18 Jul 2006 9:09 AM

Krazy Darcy

I have a search form that has one text box that is input procedure into a
query.
using query expression :

Like "* " & [Forms]![test]![keywordsearch] & "*"

That works.
I have the query run on searchform opening and a requery button to re run
the search with the user defined values (using a requery action macro)

I tried to add another two boxes and have it so the results returned depend
on which box the search request was typed into ie if only the year text box
is filled in then return anything with matching value (year is a 4 digit
number - not a date field) or if in the description box then search through
records in the description field and if the keyword box then the keyword
field.

What happened was it seems to return virtually all records regardless of
which box i enter my request in.

I used the same expression but changed the name of the appropriate text box
to match the box it's supposed to read from fr searching that field.

Have tried both "and" and "or" with similar results.

I have tried running the query directly to see if it is the form at fault or
the query and still get similar results.

Unsure if this is a query issue, form issue or both.

Thans.

18 Jul 2006 9:40 AM

Keith Wilby

Show quote Hide quote

"Krazy Darcy" <KrazyDa***@discussions.microsoft.com> wrote in message
news:BEB645AA-2F09-44B3-A5D0-4705442D1FA2@microsoft.com...
>I have a search form that has one text box that is input procedure into a
> query.
> using query expression :
>
> Like "* " & [Forms]![test]![keywordsearch] & "*"
>
> That works.
> I have the query run on searchform opening and a requery button to re run
> the search with the user defined values (using a requery action macro)
>
> I tried to add another two boxes and have it so the results returned
> depend
> on which box the search request was typed into ie if only the year text
> box
> is filled in then return anything with matching value (year is a 4 digit
> number - not a date field) or if in the description box then search
> through
> records in the description field and if the keyword box then the keyword
> field.
>
> What happened was it seems to return virtually all records regardless of
> which box i enter my request in.
>
> I used the same expression but changed the name of the appropriate text
> box
> to match the box it's supposed to read from fr searching that field.
>
> Have tried both "and" and "or" with similar results.
>
> I have tried running the query directly to see if it is the form at fault
> or
> the query and still get similar results.
>
> Unsure if this is a query issue, form issue or both.
>
> Thans.

This is the wrong group for this kind of question but I would suggest that
it's a wildcard issue - your query string will contain "Like **" for those
text boxes left blank. Have you considered using "filter by form"?

Keith.
www.keithwilby.com