AddItem

[Claire]

I'm using Access 2000 and in the VB object list included,
I don't have the ability to use the AddItem feature, and
yet as far as I can tell this AddItem feature is the only
way to Add a value to a Listbox programmatically.

Is there another solution, one that can be used with
Access 2000?

Claire

 

[Dan Artuso]

Hi,
The AddItem method is only available in Access 2002.

A listbox either gets it's records from a query, in which case you have to
add
a record to the underlying table, or it has a 'Value List', in which case
you have
to add an item to the semi-colon delimited string that makes up the list.

You can do both programmatically. In the first case, you simply execute an
Insert
statement and in the second you concatenate the value onto the exisiting
value list.

If you want the value list sorted, that's another kettle of fish.

HTH
Dan Artuso, MVP

 

[Alex Dybenko]

you can look at this article also
http://www.fmsinc.com/tpapers/97classes/index.html

 

[TC]

(snip)

A listbox either gets it's records from a query, in which case you have to
add
a record to the underlying table, or it has a 'Value List', in which case
you have
to add an item to the semi-colon delimited string that makes up the list.

Or it can get them from that specially-formatted VBA function.

TC