How about
:
________________________
Dim MyDB As Database
Dim MyRS As Recordset
Set MyDB = CurrentDb
Set MyRS = MyDB.OpenRecordset("Names", dbOpenSnapshot)
Do Until MyRS.EOF
Debug.Print MyRS!Name
MyRS.MoveNext
Loop
________________________
"luanhoxung" <lu********@yahoo.comwrote in message
news:e5******************************@localhost.ta lkaboutdatabases.com...
hi !!
i have trouble with reference in VBA
pls tell me the way to reference one field in code VBA
i used "table!<table>.field.<fieldbut errored.
i dont understand clearly the errored message