> Thnx I will try with combo, but any help for search through text box will be appreciable. Is there any examples available for such kind of a search.
>
> Regards
> Vijyendran
>
>
> > Combo box - dropdown listbox (if i'm not mistaken), have INCREMENTAL SEARCH capability.
> > How about substituting this instead of writing codes for the purpose.
> >
> > Rene-PCSO
> >
> > >
> > > i HAVE A TEXT BOX & A GRID. AS I KEYIN THE INDEXED VALUE I GET THE RESULT IN THE GRID. BUT I WANT THE SEARCH TO BE THIS WAY:
> > >
> > > AS I ENTER THE FIRST WORD , THE CURSOR SHOULD POINT TO THE STARTING LETTER OF THE VALUE IN SEQ SEARCH & AS I TYPE IN THE 2ND & 3RD WORDS, THE CURSOR SHOULD POINT TO THE RECORD CONTAINING THE NAME OF THE VALUE IN SEQ SEARCH. tHIS IS SOMETHING LIKE FINDING OF THE NAMES STATING & ENDING WITH PARTICULAR LETTERS IN VB. HOW CAN IT BE DONE IN VFP?ANYBODY TO HELP.
> > >
> > > REGARDS
> > > Vijayendran S
>
>
> Vijayendran S

on the textbox interactivechange event type this:

sele * from tablename where alltrim(This.value) = fieldname into cursor interactive order by fieldname group by fieldname

count to x
if x = 0 or EMPTY(This.Value)
	Thisform.list1.Visible = .F. && Add a listbox Object to the form
ELSE
	Thisform.list1.Visible = .T.
endif
Thisform.List1.rowsource = "interactive.orderto"
Thisform.List1.refresh