Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding CurrentRecord (Access 2003)

    I'm having problems getting the 'CurrentRecord' property to work.
    What I have is the attached code setup in a module and I use an AutoKey (F8) to execute the code. The problem is I'm getting Run-Time Error 438. When Debugging, the line with "CurrRec = Forms!F_AMLWork!F_AgileData_Parsed.CurrentRecord" is highlighted. Does anyone know how to solve this problem? I'm trying to capture what the current record is so I'm able to return to it after this script runs.

    Thanks in advance for any help,
    Drew

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding CurrentRecord (Access 2003)

    If F_AgileData_Parsed is a sub form from F_AMLWork then you should use :
    CurrRec = Forms.F_AMLWork.F_AgileData_Parsed.Form.CurrentRecord
    Francois

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding CurrentRecord (Access 2003)

    Works perfect.
    Thanks!!!

Posting Permissions

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