Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Continuous Form - Stop process of adding a new rec (Access 97 SR-2)

    I have a form where users input information about their dependents. When the form open all of their dependents are displayed. The form is set to ADDITIONS = NO. If a user wishes to add a new dependent, they click a button which sets ADDITIONS = Yes. This automatically inserts a new row for them to begin inputting data. However, as soon as they begin typing another row appears below the one where they are inputting data. I do not want this to happen. I have tried resetting the ADDITIONS = No for the form on variuos events (BeforeInsert, afterinsert, etc.).

    Does anyone have any ideas?

    Thanks,
    Sean

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Continuous Form - Stop process of adding a new rec (Access 97 SR-2)

    From what I've experienced ... Access ALWAYS shows the current line where data is being entered as well as the next (blank) new record IF you're allowing additions.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Continuous Form - Stop process of adding a new rec (Access 97 SR-2)

    The only way around it is to create a new, blank record in code and then requery the form, move to the new record and allow them to edit it. Of course, that assumes your tables will allow a blank record to be inserted--mine won't, by design.
    Charlotte

Posting Permissions

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