Prompting

S

ShrinePP92

When we use "Find," you are given a choice to search for "Whole Field" or
"Any Part of Field." When a prompt is used in a query, it only looks at
"Whole Field." I would like a Prompt to look at "Any Part of Field" so I can
select for example "German" in a field that would contain several languages
for a person.
 
B

Brian Bastl

Unless I'm misunderstanding....

Query Criteria would be:
Like "*" & [Prompt] & "*"
or
Like "*" & Forms!SearchForm!TextBox & "*"

HTH,
Brian
 
S

ShrinePP92

Thanks Brian. It worked well and did just what I wanted. I am writing a
program for the Shrine Hospital in Sacramento.

Brian Bastl said:
Unless I'm misunderstanding....

Query Criteria would be:
Like "*" & [Prompt] & "*"
or
Like "*" & Forms!SearchForm!TextBox & "*"

HTH,
Brian


ShrinePP92 said:
When we use "Find," you are given a choice to search for "Whole Field" or
"Any Part of Field." When a prompt is used in a query, it only looks at
"Whole Field." I would like a Prompt to look at "Any Part of Field" so I can
select for example "German" in a field that would contain several languages
for a person.
Click to expand...
Click to expand...
 
Top