[RESOLVED] BOOK mark

[Dbee]

I use this to extract data from a table by Account number to get the recordset book mark.

Record_Sets.Open "SELECT Quanity,Item_Number,Description,Cost_Ea,TotalCost from Equip WHERE _  Account = '" & Acct & "' ORDER BY Record", Data_Connection(1),  _ adOpenStatic, adLockReadOnly, adCmdTableDirect
Record_Sets.Close
Record_Sets.Open "SELECT Zone_Number,Description FROM Zones WHERE  _Account = '" & Acct & "' ORDER BY Record", Data_Connection(1),  _ adOpenStatic, adLockReadOnly, adCmdText
Record_Sets.Close

DDr is Declared as A String

Would I have to use> Set RRE = Record_Sets
Inorder to use the recordset bookmark for Equip table I use this RRE.Bookmark = Val(DDr(1,1)) For record one in the equipment table

I debug and then it give me the same values every time. I am thinking that will corrupt my data.

Is this the correct method for this

I need some help on this one Look on Net found Nothing that helps

[Dbee]

I was Correct on the Bookmark