query on parameters

P

Pam C

If I want to run a query and have a parameter set to ask a question, what do
I type in so when it prompts the user to enter the worksheet ID, they can
type only a few letters and it will bring up anything that starts with that.
example of parameter: Enter the Worksheet ID
I now want the user to type in Spec or the first few letters and the query
will bring back Specialized Investigation (keeps the user from getting the
wrong info)
Help
 
O

Ofer Cohen

In the criteria of the Worksheet ID field write
Like [Enter the Worksheet ID] & "*"

In SQL it will look like
Select * From TableName Where [Worksheet ID] Like [Enter the Worksheet ID] &
"*"
 
Top