Welcome to SPN

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

Sign Up Now!

How can I get a subdatasheet to update immediately?

Discussion in 'Information Technology' started by BPL, Nov 11, 2005.

  1. BPL

    BPL
    Expand Collapse
    Guest

    I have a subdatasheet(controlled by a query) I am using in a form. When I
    type in a person name(already in the database) into the form I want the
    subdatasheet to automatically show the information on the person as soon as I
    tab to the next field in the form. Currently it shows the subdatasheet only
    after I go to the next record then come back. I want it to update right away.
    I know it can be done but I don't know how. Any suggestions? Thanks
     
  2. Loading...


  3. German Saer

    German Saer
    Expand Collapse
    Guest

    in the event afterupdate of the person's name type me.form.refresh.

    hope it helps


    --
    ___________
    Thanks,

    German Saer
    Orlando, FL

    "BPL" <BPL@discussions.microsoft.com> wrote in message
    news:DEEADA42-3365-46A3-9257-7C309A4579AB@microsoft.com...
    > I have a subdatasheet(controlled by a query) I am using in a form. When I
    > type in a person name(already in the database) into the form I want the
    > subdatasheet to automatically show the information on the person as soon

    as I
    > tab to the next field in the form. Currently it shows the subdatasheet

    only
    > after I go to the next record then come back. I want it to update right

    away.
    > I know it can be done but I don't know how. Any suggestions? Thanks
     
  4. BPL

    BPL
    Expand Collapse
    Guest

    It worked! Thanks a million!

    "German Saer" wrote:

    > in the event afterupdate of the person's name type me.form.refresh.
    >
    > hope it helps
    >
    >
    > --
    > ___________
    > Thanks,
    >
    > German Saer
    > Orlando, FL
    >
    > "BPL" <BPL@discussions.microsoft.com> wrote in message
    > news:DEEADA42-3365-46A3-9257-7C309A4579AB@microsoft.com...
    > > I have a subdatasheet(controlled by a query) I am using in a form. When I
    > > type in a person name(already in the database) into the form I want the
    > > subdatasheet to automatically show the information on the person as soon

    > as I
    > > tab to the next field in the form. Currently it shows the subdatasheet

    > only
    > > after I go to the next record then come back. I want it to update right

    > away.
    > > I know it can be done but I don't know how. Any suggestions? Thanks

    >
    >
    >
     

Share This Page