Results 1 to 4 of 4

Thread: Recordset help!

  1. #1
    Join Date
    Nov 2004
    Location
    Crick, just outside Rugby
    Posts
    42

    Unanswered: Recordset help!

    Can anyone tell me what "You can't go to the specified record. You may be at the end of a recordset" means?

    This message pops up when I try to add a new record through my form.

    Thanks

    Sherri

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Check the relationships for the record.

    I've seen this happen when there is a relationship between tblA and tblB where the value added to tblA must be in tblB, but the record you're trying to write to tblA does not match a value in tblB.

  3. #3
    Join Date
    Nov 2004
    Location
    Crick, just outside Rugby
    Posts
    42

    Unhappy

    I have three computer using the same database. On one it all works fine, but on the other two - I get this message.
    It doesn't matter whether anyone else is in the database at the same time or not. It is always the same one that works ok, and the other two, not.

    Can anyone help me please?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi SherriToo,

    Not sure why it works on some and not others, but in the few cases I had where this error came up was when I tried to move to the NextRecord but was actually at the End of the records with no NextRecord to go to. Other than that I must say you have a mystery to me. Let's see if anyone else has a clue.

    BUD

Posting Permissions

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