.AddItem not supported while populating listbox from VBA

[What-a-Tool]

Have a list box that I'm trying to populate on an Access 2000 form. Created
in XP version as 2000 format.
When run in computer with Access 2000, I get an error that the .AddItem
method is not supported.

Anybody have a clue what the problem might be?

Thanks in advance.

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

 

[Cheryl Fischer]

IIRC, the .AddItem method is not available in Access 2000. Your Access
2000-format database will use it just fine while you are running it in
Access 2002 but not when you run it using Access 2000.

hth,

 

[What-a-Tool]

AddItem to ListBox IS NOT available in 2000.

Set the Row Source Type Property to 'Value List'

The following adds items from TextBox Text1 to ListBox List1:

Private Sub Command0_Click()

If List1.RowSource = "" Then
List1.RowSource = Text1.Value
Else
List1.RowSource = List1.RowSource & ";" & Text1.Value
End If
Text1.Value = ""
End Sub

(From another helpfull voice in comp.database.ms-access)

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)