Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Dale Dedoroy
  Where is Dale Dedoroy?
 Bacolod City, Negros Occidental
 Philippines
 Dale Dedoroy
 To: Brent Swails
  Where is Brent Swails?
 Lincoln
 Nebraska - United States
 Brent Swails
 Tags
Subject: RE: combo box
Thread ID: 654 Message ID: 682 # Views: 2 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, June 11, 2001 12:06:27 AM         
   


> > > I saw a combo box in access 2000 . In that combo box you can type some letters and it will show the item start with those letters you type.
> > >
> > > Is there anything with fox pro, And how.??
> > >
> > > Thanks.
> >
> > Yes you can do this with the VFP combobox. Set it's Style property to 2 (ie Dropdown List).
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts
>
> What if you only want the drop down list to display unique values. By that I mean what if the field is a list of names and you only want each name to apear once in the drop down list?

Hi Brent,
Set the Combobox RowSourceType as 3 - SQL statement and in the RowSource you define similar to this:
Select Distinct cNames From MyTable Into Cursor MyCursor

Hth,
Dale

ENTIRE THREAD

combo box Posted by cemal encami @ 6/8/2001 10:47:49 AM
RE: combo box Posted by Eric den Doop @ 6/8/2001 11:04:57 AM
RE: combo box Posted by Shawn Ottinger @ 6/8/2001 11:58:45 AM
RE: combo box Posted by chris smith @ 6/8/2001 12:23:46 PM
RE: combo box Posted by Brent Swails @ 6/10/2001 6:09:10 PM
RE: combo box Posted by Dale Dedoroy @ 6/11/2001 12:06:27 AM
RE: combo box Posted by Eric den Doop @ 6/11/2001 12:33:03 AM