Maybe I am going about this wrong but I have a record set that retrieves a field out of one of our mdb's
when I create a watch on this record set I see the data I want in it.
So I am trying to copy that data into a string variable to use elsewhere. Currently I am trying the following:
But I get the run time error 3021 and it says that no record exists.
SQL is the name of the field that I am pulling data from in the data base and I think that is what I am supposed to place in the [].
Is this the best way to go about what I am trying to do or is there a better way?
Thanks.
Code:
Set FS = db2.OpenRecordset("Select SQL FROM SCSSQL Where String_Name = 'selComponentType';")
when I create a watch on this record set I see the data I want in it.
So I am trying to copy that data into a string variable to use elsewhere. Currently I am trying the following:
Code:
FROMSQL = FS![SQL]
But I get the run time error 3021 and it says that no record exists.
SQL is the name of the field that I am pulling data from in the data base and I think that is what I am supposed to place in the [].
Is this the best way to go about what I am trying to do or is there a better way?
Thanks.