Welcome to SPN

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

Sign Up Now!

subform - new record

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

Tags:
  1. aznette

    aznette
    Expand Collapse
    Guest

    how can i get the empty record to be first in a subform rather than the last
    record? in other words, i'd like the user to tab from the main form to the
    empty record in the subform without having to scroll through a bunch of
    records.

    thanks in advance

    (i know this has probably been answered elsewhere but i sure can't find it
    anywhere)
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    aznette wrote:
    > how can i get the empty record to be first in a subform rather than
    > the last record? in other words, i'd like the user to tab from the
    > main form to the empty record in the subform without having to scroll
    > through a bunch of records.
    >
    > thanks in advance
    >
    > (i know this has probably been answered elsewhere but i sure can't
    > find it anywhere)


    Can't. You can simulate with two subforms. One set to data entry mode and the
    other with AllowAdditions set to No. If you Requery both after every insertion
    it will give you close behavior to having the new row at the top.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    Look in Help for GoToRecord. In the form's Load event put in a line
    to go to a new record.,

    Actually, if you just open the code to the Load event and enter
    Docmd.gotorecord Intellisense will help you the rest of the way.

    HTH
    --
    -Larry-
    --

    "aznette" <aznette@discussions.microsoft.com> wrote in message
    news:2B077204-31B9-4C9F-82F9-F65BD40BEA56@microsoft.com...
    > how can i get the empty record to be first in a subform rather than

    the last
    > record? in other words, i'd like the user to tab from the main form

    to the
    > empty record in the subform without having to scroll through a bunch

    of
    > records.
    >
    > thanks in advance
    >
    > (i know this has probably been answered elsewhere but i sure can't

    find it
    > anywhere)
     
  5. aznette

    aznette
    Expand Collapse
    Guest

    wow, you guys are fast. i'll try your suggestion, larry. sure beats "can't"
    which i don't think my client will be too happy about but, hey, that's his
    problem. thanks.

    "Larry Daugherty" wrote:

    > Look in Help for GoToRecord. In the form's Load event put in a line
    > to go to a new record.,
    >
    > Actually, if you just open the code to the Load event and enter
    > Docmd.gotorecord Intellisense will help you the rest of the way.
    >
    > HTH
    > --
    > -Larry-
    > --
    >
    > "aznette" <aznette@discussions.microsoft.com> wrote in message
    > news:2B077204-31B9-4C9F-82F9-F65BD40BEA56@microsoft.com...
    > > how can i get the empty record to be first in a subform rather than

    > the last
    > > record? in other words, i'd like the user to tab from the main form

    > to the
    > > empty record in the subform without having to scroll through a bunch

    > of
    > > records.
    > >
    > > thanks in advance
    > >
    > > (i know this has probably been answered elsewhere but i sure can't

    > find it
    > > anywhere)

    >
    >
    >
     
  6. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    aznette wrote:
    > wow, you guys are fast. i'll try your suggestion, larry. sure beats
    > "can't" which i don't think my client will be too happy about but,
    > hey, that's his problem. thanks.


    Just to clarify. Larry's suggestion will take the user to the new record row,
    but it will still be at the bottom, not "first" as you asked for. That is what
    I said "can't" be done without using two subforms.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  7. aznette

    aznette
    Expand Collapse
    Guest

    thanks rick. i understand what you're saying. i'll try larry's suggestion and
    see if that doesn't help. some of my client's clients contain dozens of
    entries in the subform so i can understand his desire to have the new record
    at the top of the form.

    "Rick Brandt" wrote:

    > aznette wrote:
    > > wow, you guys are fast. i'll try your suggestion, larry. sure beats
    > > "can't" which i don't think my client will be too happy about but,
    > > hey, that's his problem. thanks.

    >
    > Just to clarify. Larry's suggestion will take the user to the new record row,
    > but it will still be at the bottom, not "first" as you asked for. That is what
    > I said "can't" be done without using two subforms.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     

Share This Page