Search criteria

[heather034]

I have created a form where you enter a single digit of the first number of an area code and when you click the run query button all results of an area code beginning with the digit entered will be displayed. The problem I am having is that I can not figure out the correct syntax to put in the search criteria under the phone number field in my query. The area codes either start with a 1 or a 2. What would I put in the search criteria to do this? Thank you.

[June7]

If you want to use dynamic parameterized query, review: http://www.datapigtechnologies.com/f...tomfilter.html

Method I prefer: http://www.allenbrowne.com/ser-62.html

[heather034]

Okay, so I looked at both of your suggestions and I was able to get the query to register what I type into the text box and display results that contain the number I entered. However, for example, if I enter 1 into the form, it displays all of the phone numbers containing 1 or 2 however I only need it to display the results based on the first digit of the area code that I entered, either 1 or 2.
For example, if there is a phone number in the field that is 123-465-7890 and I entered 1 into the search form, that phone number should be one that is displayed because the first digit of the area code is 1. How do I make a search criteria for begins with to get this? I am using this:

Like ("1*") Or ("2*") & [forms]![MyFormName]![TextBox]

[CJ_London]

I think what you want is

WHERE phonenumber Like [forms]![MyFormName]![TextBox] & "*"

[heather034]

I think what you want is

WHERE phonenumber Like [forms]![MyFormName]![TextBox] & "*"

Thanks! It's working now.