Welcome to SPN

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

Sign Up Now!

Default to last record on a Form ?? Please Help?

Discussion in 'Information Technology' started by Manny, Jul 28, 2006.

  1. Manny

    Manny
    Expand Collapse
    Guest

    Hi All

    I am trying to show the last record when a form opens in edit mode. This
    form has numrous records and it defaults to the first record only.

    Can this be done?

    Appreciate your help!.
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    In the Load event procedure of the form:

    If not Me.NewRecord Then
    RunCommand acCmdRecordsGoToLast
    End If

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Manny" <manny@mdrsolutions.co.za> wrote in message
    news:e7g03e$ft2$1@ctb-nnrp2.saix.net...
    >
    > I am trying to show the last record when a form opens in edit mode. This
    > form has numrous records and it defaults to the first record only.
    >
    > Can this be done?
    >
    > Appreciate your help!
     

Share This Page