Hello there,

i've stringed a Columnname from a particular table

e.g,

Dim sQ As String

sQ = List2.ItemData(List2.ListIndex) '(e.g, value "Set Up")

'prior exists an SQL

List1.AddItem rst![sQ]

However, an error message "Item cannot be found in the...." appeared.

How can i successfully string the column name, and still use it with rst![stringed-column-name]?

Note: MS Access VBA 03

Thanks

Astro