Recordset: accessing values using variable for field name

A

Anna S

Hi
I'm wondering if anyone knows how to access the values in different fields
in a recordset using a variable for the field name?
e.g. strFieldName is a variable that holds the name of a field in the
recordset rst1.

strWord = rst1!strFieldName doesn't work, (I didn't seriously think it
would.) How do I make Access recognise strFieldName as a variable in this
statement?

Any help would be greatly appreciated.
Thanks
Anna
 

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

Recordset: retrieve values from recordset using variable for field 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
String to find Recordset Field Value 5
HELP: Using RecordSet.AddNew in a public function 5
CREATE INDEX Multiple Variables SQL 3
Adding Field Descriptions when using Create Field Method 4
use global variable and email a form 0
Autonumber field in Excel that behaves the same as Access 0

Top