private command1_click()
public Path as string
public DB as database
public Rst as recordset
if right(app.path,1)="\" then
Path=app.path
else
Path=app.path & "\"
endif
set db=opendatabasE(path & "abc.mdb")
set rst=db.openrecordset("select * from f")
with rst
if .recordcount>0 then
do while not .eof
list1.additem .field("zd")
.movenext
loop
endif
end with
end sub
我想这应该是你需要的