Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving the Current Record (Access 2000)

    I know this is probably a simple question. I am trying to save the current record as a press my Print Receipt button. I have a receipt form, and when I type up the receipt, I then press the "Print Receipt" button which then prints a receipt. But I have to go to the next record for the one I was working on to be saved so it will show up on my receipt. How do I make it so that when I press the "Print Receipt" button it saves the record so that it shows up on the receipt?

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

    Re: Saving the Current Record (Access 2000)

    Add
    DoCmd.RunCommand acCmdSaveRecord
    Before the
    DoCmd.OpenReport
    line.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving the Current Record (Access 2000)

    Thanks, Francois. It worked!

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Saving the Current Record (Access 2000)

    How is that database going? I have not heard back from you.
    Pat

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving the Current Record (Access 2000)

    It's going great! I haven't put the checks in on the Applied form that you suggested yet, but I didn't a few other cleanups. One of my schools is trying it out this weekend. She'll let me know how it went, next week. I'm keeping my fingers crossed. Thanks SO much.

Posting Permissions

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