Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post

    Change Active to Top of Continuous Form (Access 97)

    I have a main form that contains one text box and a subform which is a continuous form. At certain times I want to force the display of the continuous subform to begin at the first (top) record. Am I correct in remembering that the only way to do that is to use the RecordsetClone to position it there? I know how to use that technique but I'm just wondering if there is an easier way to just go to the first record?

    Thanks,
    Bill

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Active to Top of Continuous Form (Access 97)

    You can use

    RunCommand acCmdRecordsGoToFirst

    If you issue this instruction from the main form, you must set focus to the subform first:

    Me.NameOfSubform.SetFocus
    RunCommand acCmdRecordsGoToFirst

    where NameOfSubform is the name of the subform as a control on the main form; this is not necessarily the same as the name of the subform in the database window.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2002
    Location
    Midlothian, Virginia, USA
    Posts
    874
    Thanks
    0
    Thanked 2 Times in 1 Post

    Re: Change Active to Top of Continuous Form (Access 97)

    Hans,

    That is exactly what I needed. Thanks.

    Bill

Posting Permissions

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