VBA, How do I use contents of variable as field name(db!rst!variable)

How do I use contents of variable as field name(db!rst!variable)

Author	Message
Tom Castr #1 / 2	How do I use contents of variable as field name(db!rst!variable) When I try to use a variable to hold changing field names in a loop (fieldname1,fieldname2,etc.) VBA returns a error message that it cannot locate the column with the name (myvariable). How do I make it read the contents of the variable instead of the variable name itself ? Thanks
Sat, 17 Feb 2001 03:00:00 GMT

Ken Ge #2 / 2	How do I use contents of variable as field name(db!rst!variable) Quote: > When I try to use a variable to hold changing field names in a loop > (fieldname1,fieldname2,etc.) VBA returns a error message that it cannot > locate the column with the name (myvariable). How do I make it read the > contents of the variable instead of the variable name itself ? rst.Fields("FieldName" & i) or rst("FieldName" & i) will do it. -- Ken
Sat, 17 Feb 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]