Search Feature

  • Thread starter Thread starter Manny
  • Start date Start date
M

Manny

I made my self a search feature that consists of a Querry
with the information I need, But the Field that I'm
searching has the criteria:
[Forms]![POsMenu]![VenSearch]

This criteria ask me for the name of the vendor so it can
be searched, and a Report is given out of what has been
bought there.

The trick is that I have to type the vendor's name
completely in order to work.

How can I make a search by only the first three letters of
the vendors name?

TIA Manny
 
Thanks Maurice for the help.

I tried entering the "*" & before and after the criteria,
but It didn't work. If you know something else that might
help would be useful
TIA
Manny
-----Original Message-----
Hi Manny

Try the following:

Like "*" & [Forms]![POsMenu]![VenSearch] & "*"

Maurice


I made my self a search feature that consists of a Querry
with the information I need, But the Field that I'm
searching has the criteria:
[Forms]![POsMenu]![VenSearch]

This criteria ask me for the name of the vendor so it can
be searched, and a Report is given out of what has been
bought there.

The trick is that I have to type the vendor's name
completely in order to work.

How can I make a search by only the first three letters of
the vendors name?

TIA Manny
Click to expand...


.
Click to expand...
 
Hi again Manny

Did you put the Like in the equation...it is required for this to work.

Maurice
 
Back
Top