View Full Version : what is the best way to find record


lynn
08-03-2000, 12:26 AM
i have one interface that will allow the user to find the existing recprd. User have to type the name or any letter in the text box and the list box will highlight the match record. my problem is I used the applyfilter to find that record, it works but if there are more than 1 match record for example the user enter 'A' , results amy,anderson and i sorted it alpahebtically, the list will highlight the anderson and not the amy even though in the list it should highlight amy as it is the first record that match. whats wrong with it...or i should use other method beside applyfilter...i'm desperate..please help me...thanks in advanced

gino
08-08-2000, 08:13 AM
you can use unbound fields to fill in criteria for your query or better yet you can just use the plain standard way of using ctrl+F to find records. it depends how fancy you want to get.....