finding part of text from a table imported from excel

[fuzzyangel]

Is there a way to find a part of text from a table
that i previously imported from excel?
I don't want to use the find command from menu,
because it needs much time and i have to search for 500 records. I want to give a part of text in a cell, then to
find the first record that has this part of text, and then to move down to the next given part of text and so on.

 

[PaulBricker]

Well, you could create a Form that uses the Table as the Record Source and then use the Filter By Selection or Filter by Form tools at the top of the page/menu to get the records you want. You can either filter by a specific word(s)using the Filter By Selection or you can use the Filter by Form and filter using a wildcard value in the appropriate field.


Paul