Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: DoCmd.GoToRecord

    Im trying to use the OnCurrent event to check the value of a field. If the field is set to say 6 then it moves to the next record and checks that and so on until it finds a record where the field in question is set to say 4.

    I can seem to get it to work fine when all it has to do is skip 1 record but if 2 records or more in a sequence are set to 6 then i get a 2105 error message. Saying I cant go to the specified record.

    Ive been using:

    DoCmd.GoToRecord, , acNext

    Cheers for the help.

  2. #2
    Join Date
    Nov 2003
    Ottawa, Ontario, CANADA
    Simply introduce some error checking into your code:


    On Error Resume Next

Posting Permissions

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