Add Item in combo boxes

[Guest]

Is the additem method for comboboxes really only in XP?
97 and 2000 didn't have this? How do you fill a combo with available tables
without a dao RS and additem?

Additem is a standard VB VBA method as far back as I can remember in VB. Word
and Excel.
(e-mail address removed)

 

[Duane Hookom]

You can always loop through a collection and set the Row Source property of
the combo box to the concatenated names. With this type of combo box, the
Row Source Type is Value List. You can also use a sql string like:
SELECT msysObjects.Name
FROM msysObjects
WHERE (((msysObjects.Name) Not Like "msys*") AND ((msysObjects.Type)=1 Or
(msysObjects.Type)=6))
ORDER BY msysObjects.Name;

 

[Guest]

Thanks. I'll try that. I guess field names are just a variation.
(e-mail address removed)

 

[Duane Hookom]

There is no query method of retrieving field names. There is a special type
of combo box that displays field names.