Item cannot be found in the collection corresponding to the requested.. (valid field)

[nikhil86]

hi
I am callling a valid field from my database but for some reason i'm getting this error. Here is my code:
Dim qry2: qry2 = "Select * from requestForm where rID=" & rID
Dim rs2: set rs2 = Exec(qry,0) //Exec is a function i have d
Dim test: test = rs2("rEmail")
for some reason the recordset is not returning the value of rEmail. Any ideas??

[sashi]

hi
I am callling a valid field from my database but for some reason i'm getting this error. Here is my code:
Dim qry2: qry2 = "Select * from requestForm where rID=" & rID
Dim rs2: set rs2 = Exec(qry,0) //Exec is a function i have d
Dim test: test = rs2("rEmail")
for some reason the recordset is not returning the value of rEmail. Any ideas??

Hi there,

This error "Item cannot be found in the collection corresponding to the requested" simply means related field name cannot be found in the respective table. If you are sure of the field name(s) are valid then you should check the <Exec> function. Good luck & Take care.