Refer to fieldname using a variable

A

Alex Leonard

Thanks guys!
There is so much VBA/DAO syntax I don't know...
Also puzzled that I could not find any equvalent of that
statement in any of the MS help files and docs.

The explicit statement works:
rst(fld)="test"

So far have not been able to make the (fld) syntax work
inside a "With rst" statement though.
 
W

Wayne Morgan

Inside the With statement, you'll have to be even more explicit.

..Fields(fld) = "test"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switching from Corel Paradox to Access 2010 5
Refer to fieldname using a variable 0
Control Word from Access, use DocVariables 2
set excel cell value 19
variable inside a DAO recordset field qualifier? 3
How to make clone for bookmark and add more form when clicked? 3
Using a VBA Variable function from Access table data in Access que 5
Using Variables in a WHERE clause 2

Top