dynamic field names

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

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

e.g.

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

Or you can use

VB Code:

s = "project_id"
rsProject.Fields(s)

Thanks for the help.

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

VB Code:

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