Recordset object field reference

[heartdata]

I want to be able to reference a field in a recordset object using a variable (value assigned by user input) rather than directly by field name.

Rather than
rstMyRecordset!MyField

I want to replace MyField with a variable. What is the correct syntax?

 

[pbaldy]

This is off the top of my head, but try

rstMyRecordset.Fields(VariableName)

 

[heartdata]

Thanks! That did the job!

 

[SteveSchapel]

I am pretty sure you can also do it more simply like this:
rstMyRecordset(VariableName)

 

[pbaldy]

Happy to help. Steve is probably right; I don't think I've ever used variables for the field names, so never really needed it.