Combobox Method missing?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a AC2000 form with a standard combobox, but the Additems and removeItems methods are not available on the control. Compiling gives me a Method not found. I have the latest updates and references set correctly as best I can tell. I can use object browser on the control and it is there, just some of the methods are missing? Any ideas?
 
Todd said:
I have a AC2000 form with a standard combobox, but the Additems and removeItems methods are not available on the control. Compiling gives me a Method not found. I have the latest updates and references set correctly as best I can tell. I can use object browser on the control and it is there, just some of the methods are missing? Any ideas?


AddItem was not in versions prior to A2002.
 
I have a AC2000 form with a standard combobox, but the Additems and removeItems methods are not available on the control. Compiling gives me a Method not found. I have the latest updates and references set correctly as best I can tell. I can use object browser on the control and it is there, just some of the methods are missing? Any ideas?

Sounds like you're coming to Access from a Visual Basic background...
right?

An Access Combo Box control *is different* from a VB Combo. It's
irksome and confusing, but that's the way it is! In particular, the
AddItems and RemoveItems methods do not exist.

Instead, typically one would use a Table or a Query as the combo's
rowsource; to add records to the combo, just add a record to the
table. If you have a "Value List" combo, you need to explicitly change
the "List of Values" property (a semicolon-delimited text string) to
add or remove the values, which is enough of a hassle that I prefer to
use tables almost exclusively.
 
Back
Top