
Creating a keyword search
hello Brian
one way is to open the query in design view, delete any
parameters you have,
in the criteria of the field corresponding to edtKeyword:
"=Forms!formName!edtKeyword"
and in the criteria of the field corresponding to listbox1:
"=Forms!formName!ListBox1"
then have the button run the query.
good luck
Erez.
Quote:
>-----Original Message-----
>Hello,
>I am very green at programming Access but a coworker has
>asked me to help her implement a keyword search for her.
I
>have a text field(edtKeyword), a button(btnFIndWord), and
>a listbox(listbox1). I also have set up a parameterized
>query, however the query is not exactly handy. How can i
>use the three components mentioned above to return the
>results of my query? I have no clue where to start with
>this? Any help is appreciated.
>Thanks,
>Brian
>.