Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Om Rajan
  Where is Om Rajan?
 Jalandhar
 India
 Om Rajan
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: Search in another Form
Thread ID: 373670 Message ID: 373741 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, March 26, 2013 8:10:12 AM         
   


> >
> >
> > 1. Make a method in Child Form named Search()
> >
> > *** Search Method in Child Form
> > LPARAMETERS leSeekValue
> > *** Do the actual search here
> > 

> >
> > 2. Add a property in Parent Form named MyChildForm = NULL
> > 3. There where you run the child form:
> >
> > DO FORM ChildForm NAME thisform.MyChildForm
> > 

> > 4. In InterActiveChange event of the textbox:
> >
> > IF NOT ISNULL(thisform.MyChildForm)
> >    thisform.MyChildForm.Search(this.Value)
> > ENDIF
> > 

> >
> >
> > -----------------
> > Borislav Borissov
> >
> > Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> > The only thing normal about database guys is their tables.
>
> Hi Borislav
> thanks,
> i got the point and i do it very simply. but i got another problem when i search record from textbox. record pointer moves on
> particular record. but not get properly where cursor goes. i also set HIGHLIGHTROW = .T. but row is not highlight.
>
>
> Learning never ends
write below code exact after where u search ur record as borislav suggest in search method
lrec = RECNO()
THISFORM.GRid1.SetAll("dynamicbackcolor","iif(RECNO(THIS.RECORDSOURCE)=m.lrec, RGB(0,255,255), RGB(200,255,255))","column")

Always Fox Ahead

ENTIRE THREAD

Search in another Form Posted by Pratik Singh @ 3/25/2013 7:42:36 AM
RE: Search in another Form Posted by Borislav Borissov @ 3/25/2013 8:51:34 AM
RE: Search in another Form Posted by Pratik Singh @ 3/26/2013 7:39:24 AM
RE: Search in another Form Posted by Om Rajan @ 3/26/2013 8:10:12 AM
RE: Search in another Form Posted by Borislav Borissov @ 3/26/2013 8:29:47 AM
RE: Search in another Form Posted by Edwin Lopez @ 3/25/2013 8:59:43 AM
RE: Search in another Form Posted by Borislav Borissov @ 3/25/2013 9:46:19 AM
RE: Search in another Form Posted by tom knauf @ 3/25/2013 1:55:50 PM