Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo boxes
Message
From
13/12/1999 21:18:21
 
 
To
13/12/1999 18:17:21
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00303051
Message ID:
00303119
Views:
22
>Hello all...
>I've got a combo box in a search form in a project containing 6 separate tables. I need to pass the combo box the name of a table to display it's field names(In drop-down list format.). The problem is, is that I'm trying to use a single combo box for all six tables. My question is: How do I pass either to the builder or in code form the name of the table as a variable. So that when the form opens(The database has been chosen on the previous form in the formset.) The combo box will list all of the fields in that particular table.
>
>Any suggestions, comments, loaded weapons to shoot myself with...
>My superiorers told me it couldn't be done- I don't beleive them...
>
>Tom Welch

***Form.Init event
LPARAMETER cTablename
Select (cTablename)
With This.Mycombobox
 .rowsourcetype=0
 .sorted=.t.
 .clear
 For nLoop=1 to Fcount()
  .additem(field(nLoop))
 Endfor
Endwith
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform