"Find" by description options

[Very Basic User]

Hello,

I have a seperate query (SearchByDescription) that currenty has no commands
to filter. I have a report (ReportByDescription) that will show a detailed
record of an item. What I want is a command button on another form that when
I click the botton, It asks me to type as much as I know or a key work that
will look at the "Short Description" section of the record through the query.
This way, I can have users look for information with limited information and
scroll thorugh the records that are produceded as a result to find what they
are looking for. If I use the "Find" option on a table the criteria would be
to look in the "Short description" field using any part of the field.

I hope I've not made this more confusing than it is.

Thanks,
John

 

[John W. Vinson]

Hello,

I have a seperate query (SearchByDescription) that currenty has no commands
to filter. I have a report (ReportByDescription) that will show a detailed
record of an item. What I want is a command button on another form that when
I click the botton, It asks me to type as much as I know or a key work that
will look at the "Short Description" section of the record through the query.
This way, I can have users look for information with limited information and
scroll thorugh the records that are produceded as a result to find what they
are looking for. If I use the "Find" option on a table the criteria would be
to look in the "Short description" field using any part of the field.

I hope I've not made this more confusing than it is.

Thanks,
John

It would help a great deal to have some idea about the structure (name,
fieldnames, datatypes) of your table. My guess is that you would open the form
using a filter such as

LIKE "*" & [Forms]![FirstForm]![txtDescription] & "*"

You are using forms (which have programmable events) rather than query or
table datasheets (which don't), I hope...?