.AddItem not supported while populating listbox from VBA

  • Thread starter Thread starter What-a-Tool
  • Start date Start date
W

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)
 
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,
 
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)
 
Back
Top