Click to See Complete Forum and Search --> : record sets


January 28th, 2000, 10:30 AM
I have the following: Dim db as database, Dim rsbiograph as recordset, Sim rsDoNotEmail as recordset, dim rsEmailTracking as recordset.
Set rsbiograph = db.openrecordset("biograph", dbopendynaset)
set rsDoNotEmail = ....
Set rsEmailTracking = ....

when i get to rsBiograph.FindFirst "StuID = '" & strAL_SID & "'" i get the following error message
object variable or with block variable not set (error 91)

Can anyone help me with this?? I woudl really appreciate it..

Thanks a lot

Lothar Haensler
January 28th, 2000, 10:50 AM
if your code is complete,then there is the OpenDatabase call missing for the db variable.
you need to open the database before you can open recordsets.

January 28th, 2000, 11:27 AM
Thanks for replying.
I am aware of the solution you gave me but my current problem is that when I used only one recordset, the program worked. Now
that I added two more recordsets, it gives me an error message (object variable or with block varible not set). Do you know anything
about this error message? If so, please shed some light :)
Thanks