Dynamic Recordet 1

[TimTDP]

In Access 2000, I want to refer a recordset dynamically

for example:
Set rst = dbs.OpenRecordset(TableName)
AAA = field name - field name is set elsewhere and this is the dynamic piece of code

With rst
intDataValue = rst!AAA

I get an error "item not found in this collection.

What is the correct syntax?

 

[jadams0173]

dim F as string
dim db as dao.database
dim rs as dao.recordset

f="field"
set db=currentdb
set rs=db.openrecordset("tablename")

yourvar=rs.fields(f)


I tried to have patience but it took to long! -DW