[RESOLVED] MS Access VBA addItem List view

[FishGuy]

OK yes add item is on 2003 and im on 2000.
I have a workaround by using a value list
i.e Build a comma delimited string then
Me.lstEmpStates.RowSource = strStates

My trouble now is building the string

While Not rs.BOF And Not rs.EOF

strStates = strStates & ";" & rs.DataMember(0, 1)
rs.MoveNext

Wend

As you can see I am just wanting to get column 1 into the string as I loop through the record set but the syntax is wrong.

hlp pls

[Ecniv]

what is rs?
what is datamember?

if rs is a recordset then use rs("<fieldname>") - will work except (possibly) for null values.

Also there is a character limit on the list box for values, but if you are not going near that limit you should be ok.

[FishGuy]

Thanks Ecniv
http://msdn.microsoft.com/library/de...html/ino2k.asp

Also keep in mind that there's a limit on just how long a control's RowSource property can be, and that limit is 2,048 characters

I think that should be enough