Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Sydney, Australia
    Posts
    11

    Unanswered: Recordset: BOF=True,EOF=True;RecordCount>0

    Ran into a strange situation:

    Set a recordsetClone from a subform, and found that it returned BOF=True, EOF=True, and RecordCount=9 !!!

    The only time when BOF and EOF are both True is when there are no records in the recordset - or so I've always thought! No?

    Anyone have any idea on this?


    MTIA
    Max Hugen
    Hugen Enterprises Pty Ltd
    www.hugen.com.au
    Australia

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    It is not possible to have EOF True & BOF True & RecordCount >0
    Try to make a query with the same conditions and see wheater it results 9 Records or not

  3. #3
    Join Date
    Nov 2002
    Location
    Sydney, Australia
    Posts
    11
    Ahem.... it SHOULD NOT be possible........

    However, I'm checking a subform on Load to see if it has records, so I can do a Find, and have run into code errors because BOF and EOF are True, despite the recordsetClone having a recordcount>0 (the recordcountwas in fact correct).

    Perhaps the form is corrupted.
    Max Hugen
    Hugen Enterprises Pty Ltd
    www.hugen.com.au
    Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •