Search Feature

[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

 

[StCyrM]

Hi Manny

Try the following:

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

Maurice

 

[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

.

 

[StCyrM]

Hi again Manny

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

Maurice