Re: Query to search entire record, not one field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your help Rick.
I understand the second part but am not sure about the first half.
My Table name is "Master"
My Search form is "Search" and is based on a different table with the same
fields as "Master" But I think it should be based of a query of "Master" ??
So I need a blank form that you can type in the information you want to
search by and then click search and all records with the matching information
will show up.
I tried to put in Like Forms! [Search]![State] & "&" but it put Forms! in []
and when I ran the query it gave me the pop up asking for Foms!Search!State!,
I undertand why I got the pop up but I don't want the pop up, I want to enter
the information into a blank form and then search.
Thanks again.

"Rick B" wrote:

> To search based on a filed in a form that may or may not contain a value,
> you'd use...
>
> Like Forms![MySearchFormName]![MySearchFieldName] & "*"
>
> Putting this in all the various fields in your query would pull values that
> match if the user had made an entry. If no entry was made for a particular
> field, then all the values in that field would be valid.
>
> --
> Rick B
>
>
>
> "consjoe" <consjoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:BE45E375-8EE8-48ED-BC84-EE30F1C30CB5@xxxxxxxxxxxxxxxx
> > I have a form based on a table with 20 fields. My clients want the
> ability
> > to search all fields to find the record they are looking for. Is there a
> way
> > for me to create a form (with all 20 fields) where they can chose which
> > fields to search by and those records come up?
> > Ex. I know that state, company, and first name of a record I need. I go
> > into the 'Search Form' and type that information in and that record is
> > retrieved.
> > It is kind of like an and/or type of query but they need to be able to
> > choose which fields to search by and leave the others blank.
> > Thanks in advance.
> >
>
>
>
.

Relevant Pages

  • Re: Query to search entire record, not one field?
    ... > in criteria for all fields in my Query. ... > There is not information for the "State" field in my master table for this ... >> Rick B ...
    (microsoft.public.access.queries)
  • Re: Query to search entire record, not one field?
    ... You need to build an unbound form. ... You can then reference each of these in your query. ... > Thanks for your help Rick. ... >> match if the user had made an entry. ...
    (microsoft.public.access.queries)
  • Re: Invoices
    ... Sorry - you lost me. ... "Rick B" wrote: ... If the form is also used to view data, it will often be bound to a query. ... perhaps you have the "data entry" property set to ...
    (microsoft.public.access.forms)
  • Re: Form doesnt show added table information
    ... there -is- a query behind it. ... I believe Rick was probably on the right ... "KARL DEWEY" wrote: ... I checked and there are no filters. ...
    (microsoft.public.access.forms)
  • Re: Cant see "Form View" or "Layout View"
    ... Thanks Rick. ... If I have the same 6 tabs, but place all my information and controls on ... A bound form is simply a GUI to a table or query it is bound to. ... Assessments.DetailedElementsIDF) INNER JOIN (CriteriaSheet INNER JOIN ...
    (microsoft.public.access.forms)