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