>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