A
apollo8359
Basically, I want both forms to use the same recordset. I figured out how to
get the first form to open with a recordset but because I am unsure what
every line does, I am not sure how to get the second form to reference it. Is
there some way to name a recordset so I can reference it later? Anyway, here
is what I have so far.
Public db As DAO.Database
Public rs As DAO.Recordset
Public strSQL As String
Set db = CurrentDb()
strSQL = "Select * from qryBigLog Order by [Opened] DESC;"
Set rs = db.OpenRecordset(strSQL)
Additionally, I need the second form to open on the record in the first
form. The LogID field is the primary key. And finally, what is the fastest
way to get to that record, findfirst off a recordsetclone or gotorecord off
the recordsource? Thanks for your help.
Michael
get the first form to open with a recordset but because I am unsure what
every line does, I am not sure how to get the second form to reference it. Is
there some way to name a recordset so I can reference it later? Anyway, here
is what I have so far.
Public db As DAO.Database
Public rs As DAO.Recordset
Public strSQL As String
Set db = CurrentDb()
strSQL = "Select * from qryBigLog Order by [Opened] DESC;"
Set rs = db.OpenRecordset(strSQL)
Additionally, I need the second form to open on the record in the first
form. The LogID field is the primary key. And finally, what is the fastest
way to get to that record, findfirst off a recordsetclone or gotorecord off
the recordsource? Thanks for your help.
Michael