Form: Searching Question 1

[Mreid99]

I have a standard form, when I place the cursor on a field and ask to do a search for a name, it will not find the individual. The employee last name, first name is displayed. When I ask it to look for the employees ID it will find them.<br>
<br>
I know the form is based on the employee ID, but I'd like to search based on the name, either first or last name.<br>
<br>
Thnks in Adv.

 

[rochelle]

First check the settings of the checkboxes in your search window.<br>
<br>
Is Search Only Current Field checked? Is your cursor in the right field?<br>
<br>
Are employee last name, first name in a single field in your form? If not, use a filter instead of Find.<br>
<br>
Have you tried copying the actual data from a field and then pasted the name into the find window?<br>
<br>
Have you tried using wildcards?<br>
<br>
Is this a calculated field?<br>
<br>
We need more details in order to help.<br>
<br>
Rochelle

 

[DougP]

In some case's ODBC data is always in Upper case.<br>
If you are keying in an employees name in lower case it will not find it.<br>
Because you said you can find the ID. <br>
<br>
Try turning on CAPS lock and see if that works when you try to search.<br>
Also Go in the Table view and sort Alphabetically scroll down to see if you can find employee data to make sure it is spelled correctly.<br>
I sometimes copy and paste the data in my find box.<br>
Check this too. <br>
If you are searching for Mary Smith and you key in MA make sure in the find box that &quot;Match&quot; to something other than &quot;Whole Field&quot;<br>
<br>
Hope this Helps.<br>

 

[Zelandakh]

Sounds like a very common problem in that you have the field storing the ID but showing the cust name. Therefore, the invisible field (the ID) is what is searched on and that fails as you know when you search for a name but works fine when you search for the ID number which is useless to your users.<br>
<br>
That's the problem, but I don't know how to cure it. Soz.

 

[Mreid99]

When I select the match case, It finds the names, How interesting. Thanks for all of the responses.<br>
<br>
Mark.. Have a Merry xMas