Prompting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Unless I'm misunderstanding....

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

HTH,
Brian
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted Prompts 4
Count text values in a Access Field 0
Make table query: [Enter 1] AS Test 1
Deleting Rows In a Database 1
Using Prompt with a "like" query parameter 2
One prompt for Four Queries 3
Want to place a prompt on a field created by using DateAdd 4
Using a parameter 1

Back
Top