faced with another dilemma, i want to know how many records my search found within the current recordset, using myRS.Find "Codes LIKE '*CR21*'". i know that there are let's say 7 records, but i would like to use that value found to display only those records the search found matching my search.

michael j hemmington

__________________
michael j hemmington

You got to use % instead of *

_________________________
- Vijay G
Strive for Perfection

it still ownly displays the first record it finds. i would like the specific page to display codes "SPKCR2101" to "SPKCR2107" in a table and leave out all the others that has no affect. i already know that looping controls won't work, so i have to find another way around that. i tried declaring a variable to write the number of records found with the criteria "CR21", but still only the first record. how would i loop out the other 6 without displaying the entire recordset?

michael j hemmington

Can you post some code here, else it is hard to find where you go wrong.

_________________________
- Vijay G
Strive for Perfection

thnx for the help, but i found my problem! i had to filter out the specific records instead of finding them lol. again thank you.

michael j hemmington