Add Item function for Access 2000

[fvela]

i posted an earlier question about the addItem method and found that it was
missing in versions of Access earlier then 2002 ... working in Access 2002 is
not an option at the moment...
is there anyone out there who can send me a function that would create an
addItem method....

thanks

 

[MacDermott]

If you are using a valuelist as the combobox's rowsource, you can write code
to append to that list; just separate entries with semicolons.
If you're referencing a table/query for the rowsource, you'll have to add
items to the table.
In this case, these will be permanent additions; they'll show up next
time you open the form unless you write some other code somewhere (e.g.
Form_Unload) to remove them from the table.
In either case, requery the combobox to show the new entries.

HTH
- Turtle