Find record / a find querie

[Guest]

Hi. I want to create a querie with multiple criterias.

In my form, I have several fileds to find a product.

Nop Name Family Brand Type Factory

So imagine that in the form user only fill the NOP field, or fill only the
name and brand.

I need to make this querie to loockup a value even if some fields are not
fieled.

By the way, if it's possible in the name filed could be possible to look for
any part of of the field??

Thanks,

Regards,
Marco

 

[Allen Browne]

For a downloadable example of how to build such a form, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

That example shows how to match any part of the name.

BTW, it is not a good idea to have a field called "Name". Nearly everything
in Access (including forms) has a Name property, and Access gets confused
about whether you mean the Name text box on the form, or the name of the
form itself, so your results are inconsistent.

Here's an (extensive) list of the field names to avoid using:
http://allenbrowne.com/AppIssueBadWord.html

 

[Guest]

Thanks.

For a downloadable example of how to build such a form, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

That example shows how to match any part of the name.

BTW, it is not a good idea to have a field called "Name". Nearly everything
in Access (including forms) has a Name property, and Access gets confused
about whether you mean the Name text box on the form, or the name of the
form itself, so your results are inconsistent.

Here's an (extensive) list of the field names to avoid using:
http://allenbrowne.com/AppIssueBadWord.html