Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limiting choice in drop down list
Message
From
05/10/1998 22:37:06
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00143999
Message ID:
00144094
Views:
25
Jim,

Does this only work for rowsourcetype None or does it work in other types as well. I tried using a backslash with a SQL statement (type 3 I think) and it didn't disable the selections.

>Bruce,
>
>IN the combo's requery put this code;
>
>
>* Combo Requery
>LOCAL lnNewItem
>WITH THIS
>   lnNewItem = .NewItemId + 1
>   SCAN
>     IF Active
>         .AddListItem(Name,lnNewItem,1)
>     ELSE
>         .AddListItem("\"+Name,lnNewItem,1)
>     ENDIF
>     lnNewItem = .NewItemId + 1
>    ENDSCAN
>ENDWITH
>
>
>Now set the rowsourcetype to None and the rowsource is blank.
>
>Whenever you need to update the combo call its requery.
***************************
Bruce Gilmour

"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform