<div>
AddItem and RemoveItem aren't part of the Listbox object<br />
until Access 2002. Even then I think they are limited in the same way a ValueList is limited.<br />
<br />
You might be interested in this article explaining how to write a class to add these two methods to a listbox or combobox in versions prior to 2002.<br />
<br />
<a href="http://www.fmsinc.com/tpapers/97classes/index.html" rel="ugc">http://www.fmsinc.com/tpapers/97classes/index.html</a>
</div>


AddItem and RemoveItem aren't part of the Listbox object
until Access 2002. Even then I think they are limited in the same way a ValueList is limited.

You might be interested in this article explaining how to write a class to add these two methods to a listbox or combobox in versions prior to 2002.

http://www.fmsinc.com/tpapers/97classes/index.html [http://www.fmsinc.com/tpapers/97classes/index.html]

<div>
AddItem and RemoveItem are methods of the ActiveX list box<br />
<br />
Insert ActiveX Control: Microsoft Foroms 2.0 Listbox<br />
<br />
hth
</div>


AddItem and RemoveItem are methods of the ActiveX list box

Insert ActiveX Control: Microsoft Foroms 2.0 Listbox

hth

<div>
Thanks. &nbsp;The manual input idea is a good one, but I think the best solution is just to update my version of Access.
</div>


Thanks.  The manual input idea is a good one, but I think the best solution is just to update my version of Access.

<div>
<div class="content wysiwyg-content">
I cannot seem to gain access to the methods addItem and removeItem for a listbox in Access 2000 VBA.<br />
<br />
The error I get is: &quot;Compile error: Method or data member not found&quot;.<br />
<br />
I figure its as simple as going to Tools | References and selecting the proper reference, but I can't seem to figure it out - especially since the same program worked fine at work.<br />
<br />
Any ideas?
</div>
</div>


I cannot seem to gain access to the methods addItem and removeItem for a listbox in Access 2000 VBA.

The error I get is: "Compile error: Method or data member not found".

I figure its as simple as going to Tools | References and selecting the proper reference, but I can't seem to figure it out - especially since the same program worked fine at work.

Any ideas?

AddItem and RemoveItem methods are unavailable for listbox

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.