Using a variable as a field name

T

TShirah

How do I tell Access that I am using a variable to name a
field so I cna change fields on the fly: Example
rsEquip![May] = "somevalue" where rsEquip is a
recordset and May is a field name.

strField = Format(Date,"mmm")
rsEquip![Value of strField] = ....
 
T

TShirah

Great! Works like a charm!! Thanks a bunch!
-----Original Message-----
How about ...

rsEquip.Fields(strField)


hth,
--

Cheryl Fischer, MVP Microsoft Access



How do I tell Access that I am using a variable to name a
field so I cna change fields on the fly: Example
rsEquip![May] = "somevalue" where rsEquip is a
recordset and May is a field name.

strField = Format(Date,"mmm")
rsEquip![Value of strField] = ....
Click to expand...


.
Click to expand...
 

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

dynamic field name 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Copy previous record into form field 0
Tracking changes to a form's fields---still searching for an answe 7
VBA - exporting serial letters to single documents 0
Finding the proper style field and the numbered paragraph value within the style 0
Tracking changes to a form 3
ASK Field Formatting 1

Top