dynamic field names

[masTermaTT]

I have a program that will connect to different databases depending on the information sent to it.

Instead of hardcoding the recordset fields into the program I'd like to know if i can define the fields at runtime.

Instead of:
"rsProject!project_id"
I'd like:
"rsProject!<AnyString>"

I hope this is enough information.

Thanks

[Gaffer]

You can use this format - rs("myField")

e.g.

strFld = "myField"
debug.print rs(strFld)

[swatty]

Or you can use

s = "project_id"
rsProject.Fields(s)

[masTermaTT]

Thanks for the help.

[si_the_geek]

You can also use numbers to get the field, eg:

Dim I as Integer
For I = 0 to rsProject.Fields.Count -1  '(fields is 0 based)
  Msgbox rsProject.Fields(I)
Next I