G
Guest
I have a database of apparel items. My goal is to have a switchboard button
that users can click that will prompt them to enter a keyword or keywords
that they want to look for anywhere in the item name. For example, if they
type "floral", items such as "Floral Tights", and "Knit Floral Top" will
display. The filter I currently have has the criteria "[Enter item name]"
for the criteria, but of course it only dipslays results if the user knows
the complete name of the item. If they are looking for the Knit Floral Top,
and just type "Floral Top" (because they don't know the exact name), they of
course don't the correct result.
The only way I know how to search in any part of the field (as opposed to
the whole field) is by using the Find function while in the form. I'm sure
there's some way to do this in a filter that I could then turn into a macro,
then assign to the switchboard button. I'll bet it's something simple, but
I'm fairly new at Access and can't seem to figure it out. Please let me know
if more information is needed. I appreciate all assistance.
that users can click that will prompt them to enter a keyword or keywords
that they want to look for anywhere in the item name. For example, if they
type "floral", items such as "Floral Tights", and "Knit Floral Top" will
display. The filter I currently have has the criteria "[Enter item name]"
for the criteria, but of course it only dipslays results if the user knows
the complete name of the item. If they are looking for the Knit Floral Top,
and just type "Floral Top" (because they don't know the exact name), they of
course don't the correct result.
The only way I know how to search in any part of the field (as opposed to
the whole field) is by using the Find function while in the form. I'm sure
there's some way to do this in a filter that I could then turn into a macro,
then assign to the switchboard button. I'll bet it's something simple, but
I'm fairly new at Access and can't seem to figure it out. Please let me know
if more information is needed. I appreciate all assistance.