recordset调用

george

表1中有列:ID,NAME,CITY

我使用如下代码,想读出所有的CITY

dim rc as dao.recordset

set rc = currentdb.openrecordset("表1")

dim i

for i = 1 to rc.recordcount

msgbox rc.CITY

next

哪里错了?

[此贴子已经被作者于2004-12-22 13:00:22编辑过]

zhengjialon

rc.CITY改成rc("CITY")