Criteria in a query

  • Thread starter Thread starter Lorena
  • Start date Start date
L

Lorena

Hi

I have a query designed to list all the names and phone
numbers of business associates. under the criteria section
in design view, I have it saying [Enter name]. But if the
person does not know how to spell the name correctly, how
can I make it so that the criteria field will accept only
the first few letters and match it to the columns?

Does this make sense? I'm completely new to access.

Thanks in advance.
 
To make sure that only certain names are allowed, you will have to set this
up as a form using a combo box instead of the default criteria windows.
Then by setting the LimitToList property of the box to Yes, only names in
the table will show up. Then you will have to add code to call up the query
using this combo box. Let me know if you want to try this.

Kelvin
 
Lorena,

Like [Enter Name] & "*"

Copy the above line into the criteria field. This
should work, let me know if you have any problems.

Joe
 
Back
Top