Filter (ADO) code - 2nd part

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First of all, thanks to Brendan and Van for the help in my previous thread. I am successfully to filter a sub-recordset. After the filter, I want to do 2 things.
(1) Debug.Print rst1.GetStrin
(2) Me!ProductDescription = rst1.ProductDescriptio

However, after the fisrt statement, I get a error message for the second statement saying that I cannot do the assignment because the required record is deleted or unavailable etc. I have to put rst1.MoveFirst in between the 2 statements. I wonder how the cursor moves. It seems it moves to EOF after the print. In a normal case, I am referring to other database, the cursor should stay at the same record until the MoveNext

Any one have experience with this?
 
I read some books mentioned that actually we may need to tell GetString to print how many rows. In my case, I do not supply the parameter. So GetString prints all rows of the recordsets. Therefore this may cause the cursor points to EOF. If I inform GetString to print 5 rows, after the event the cursor should points to the 6th row. Can anyone correct me of my understanding?
 
Back
Top