Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms & Reports (A2k/XP)

    Hello All:

    I have a form that is based on a query. On the form is button that print previews a report. Information on the report is based on the same query. If the user makes a change on the form, that change is not reflected on the report until the form is closed and reopened. I have a feeling I need either a refresh or a requery but am not sure as to where it goes. As always, TIA.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Forms & Reports (A2k/XP)

    You just need to save the current record before you actually open the report. Something like this should work:

    If Me.dirty = True then Runcommand accmdSaveRecord
    docmd.OpenReport "... yada yada..."
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms & Reports (A2k/XP)

    Thanks Mark, that seems to have done the trick.

Posting Permissions

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