Browse field content

[CortoMaltes]

I'm looking into allowing my users to browse data input in a field by indicating the starting word or phrase and browse all data input containing the word or phrase and all data thereafter. Any ideas on how to do so? Thanks in advance for hints in this respect.

 

[AWithers]

I would suggest a recordset based on a query with a where clause that includes like

e.g.

select * from yourtable where yourfield like '%'+stringinputbyuser+'%'


Andy

 

[CortoMaltes]

Sorry Andy but that will return all records matching the word or phrase input and only those. What I'm looking for is to provide a list records where the data matches the user input and/or anything thereafter, browsing the field contents starting at the point the user indicates