Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: Error 2105 in VBA Access

    Hi All
    I am working on continous subform, i wanna pass current record LineNumber to Next record...here is the code
    DoCmd.GoToRecord ,,acNewRec


    But this gives me error message saying " I cant go to specified record" any help will be appreciated.
    Thank you in advance

  2. #2
    Join Date
    Jun 2002
    Location
    Saudi Arabia / Philippines
    Posts
    126
    Quick thought: At the time of executing the GoToRecord is the current record the main form?
    Rod

    fe_rod@hotmail.com

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i think 2105 is a "can't go to specified record" error: typically an attempt to move beyond BOF or EOF but in your case you are trying to go acNewRecord... have you got Properties/Data/Allow Additions: Yes ???

    if YES, is A still running something that has not completed at the time you try to go to acNewRecord ??? to check this try:

    for i = 1 to 10000
    doevents
    next
    DoCmd.GoToRecord ,,acNewRec


    izy
    currently using SS 2008R2

Posting Permissions

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