Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2001
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Carry field info to next record (WinXP Access 2000)

    Is there a simple way to carry field information forward to the next record? For example, in FoxPro, there is a command called 'set carry on' that allows a person to enter data into a field and populates the next record same field with that same information. The information can be changed at any time and the newer info will be carried to the next record, etc., saving lots of time with data entry. Any help will be appreciated.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Carry field info to next record (WinXP Access 2000)

    There isn't a really simple way of doing it automatically - that requires some VBA code. There is however a keystroke combination CTRL-' which does copy info from the previous record into the same field that currently has focus. One of the reasons that isn't always a good idea is that with Access you can have filters and sorts which change the value of the previous record - but if you know for sure that as you enter the next record that you want to copy data from the current record some VBA will do the trick. If you want some guidance on doing that, one of the loungers would be more than willing to help.
    Wendell

  3. #3
    Lounger
    Join Date
    Mar 2001
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Carry field info to next record (WinXP Access 2000)

    Thanks, Wendell. We'll give the keystrokes a try. I would also be very interested in the VBA code if someone will post it. Thanks again for all the help.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Carry field info to next record (WinXP Access 2000)

    The method to copy fields from the previous record is described in How to fill record with data from previous record automatically in Access 2000. This MSKB article also contains a link to download a sample database with a working example.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Carry field info to next record (WinXP Access 2000)

    u can do it by Access . see that example.
    Ashraf

Posting Permissions

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