Welcome to SPN

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

Sign Up Now!

Access form Refresh

Discussion in 'Information Technology' started by James O, Oct 29, 2005.

  1. James O

    James O
    Expand Collapse
    Guest

    Hey All,

    Quick question. Is it possible to refresh a form without closing it and
    re-opening it? I have a form connected to a query there is a check box on the
    form marked complete. The query says show records that dont have complete
    checked. I have a button on the form that marks groups of accounts as
    complete. So when they click the button I want the accounts to fall off the
    form as they do if I close and re open it. Thanks!
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "James O" <JamesO@discussions.microsoft.com> wrote in message
    news:77843DD7-8A91-436B-A41E-B24166D7A99C@microsoft.com
    > Hey All,
    >
    > Quick question. Is it possible to refresh a form without closing it
    > and re-opening it? I have a form connected to a query there is a
    > check box on the form marked complete. The query says show records
    > that dont have complete checked. I have a button on the form that
    > marks groups of accounts as complete. So when they click the button I
    > want the accounts to fall off the form as they do if I close and re
    > open it. Thanks!


    This is not a Refresh operation, but a Requery opeartion. The line of
    code you want (for a command button on the form) is

    Me.Requery

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page