writing code to populate a list box in access

[fvela]

i am having serious troubles figuring how to add items to a list box in
access 2000, it is a no brainer for access 2002, but access 2000 is missing
the add item method for list boxes...
i using the value property or rowsource property does not work....
ie
listbox.value specifies which value is selected
and listbox.rowsource can only be set if the Rowsourcetype property is a
table/query

any ideas how i can take my access 2002 code ie. listbox.additem (..)
and make it work in access 2000...
i know i need to write a function for the method, however i have no idea how
to do so in vba... is there anyone out there who can help me??

thank you
Flav

 

[MikeB]

Private Sub Command0_Click()
ListAddItem TheNameOfMyListBox, TheStringToADD

End Sub

Private Sub ListAddItem(LB As ListBox, strItemToAdd As String)
If LB.RowSource = "" Then
LB.RowSource = IIf(LB.RowSource = "", strItemToAdd, "")
Else
LB.RowSource = LB.RowSource & ";" & strItemToAdd
End If
End Sub

 

[fvela]

I love you!!!.. thank you so much... honestly i was so frustrated with
this....
thanx again

 

[MikeB]

Thank you for your kind words. I don't know much, but I knew this one....