Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Macro

Discussion in 'Information Technology' started by Jose Aleman, Nov 15, 2005.

Tags:
  1. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    Hi

    I have a report on a form that is run by a macro. On the report I have a
    Memo field. When the user clicks on the report to run the report for current
    record, any information recently type on the memo field does not appear. The
    user has to go to the next record, return and run the report again.

    Does anyone know why they have to do this and how I can fix it?

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    Microcosm and Macrocosm Gurmat Vichaar Mar 20, 2009
    Adobe Unruffled by Macromedia Restatement (AP) Interfaith Dialogues May 4, 2005
    Macromedia Flash animation and designing. Interfaith Dialogues Oct 21, 2004

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 14 Nov 2005 09:22:03 -0800, "Jose Aleman"
    <JoseAleman@discussions.microsoft.com> wrote:

    >Hi
    >
    >I have a report on a form that is run by a macro. On the report I have a
    >Memo field. When the user clicks on the report to run the report for current
    >record, any information recently type on the memo field does not appear. The
    >user has to go to the next record, return and run the report again.
    >
    >Does anyone know why they have to do this and how I can fix it?
    >
    >Thanks


    A record currently being edited on a Form is just on the Form - not
    yet written to the database.

    I don't use macros much, but I think you can put a line in the macro
    before it opens the report to save the current record: IIRC it's the
    SaveRecord action.

    John W. Vinson[MVP]
     

Share This Page