Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Kulwant Singh
  Where is Kulwant Singh?
 Shimla
 India
 Kulwant Singh
 Tags
Subject: RE: auto maximising form
Thread ID: 112145 Message ID: 112209 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Monday, November 06, 2006 7:32:37 AM         
   


> > > Hello all,
> > > I need help with a form.
> > > When I select rowsource type as fields the form remains the size it is meant to be BUT
> > >
> > > 1) when I select rowsource type as SQL statement, the form automatically expands to cover the whole screen. Why is this happening?
> > >
> > > 2) an 'unwanted' Browse window appears on the screen when I requery() the combobox. Can the appearance of the browse window be suppressed ?
> > >
> > >
> > > thanking you,
> > > kulwant

> >
> > Kulwant,
> >
> > Your problem is that your SELECT command does not have an INTO CURSOR clause. Try that same SELECT command in your command window and it will pop a browse window. When you run your app, it will also pop a browse window - but it pops the browse window in the active form - not good. In your case, it is maximizing the window to show the browse - also not good. Set your rowsourcetype to 1 - Alias and in your SELECT command, add an INTO CURSOR clause and it will solve both problems for you.
> >
> > SELECT ... FROM ... WHERE ... INTO CURSOR MyListCursor
> > ThisForm.MyListbox.RowSourceType = 1
> > ThisForm.MyListBox.RowSource = [MyListCursor]
> > 

> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)

>
> Thank you, Sir,
>
> and I also thank all the other members for their guidance and support,
>
> I'll bother you again with more questions...
>
> thanks!
>
> kulwant


Consider rating Ken's reply if it was helpful for you. I shows others that the reply contains good information.

Boudewijn LutgeĀ®ink
The attitude of "An eye for an eye and a tooth for a tooth" will make this world toothless and blind (Ghandi)

ENTIRE THREAD

auto maximising form Posted by kulwant singh @ 11/4/2006 1:46:06 PM
RE: auto maximising form Posted by Ken Murphy @ 11/4/2006 2:11:26 PM
RE: auto maximising form Posted by kulwant singh @ 11/4/2006 3:14:38 PM
RE: auto maximising form Posted by Boudewijn Lutgerink @ 11/6/2006 7:32:37 AM