Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform scrolls up after each line (2000)

    I have a subform that is used to enter transaction data. It works, but after each line has been entered the form scrolls up (or is it down) by one line. The effect of this is that the line you have just entered disappears. It is still there, it's just gone off the top of the screen. You can bring it back by clicking on the top arrow of the vertical scrollbar. Unfortunately, to the users, it just looks as though their input has not been accepted.

    There's room for about 10 lines on the form and the normal behaviour would be that the form would fill all of these lines before it started scrolling. Is there a setting somewhere that controls this?

    Ian

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

    Re: Subform scrolls up after each line (2000)

    Does the subform have an unnecessarily high header or footer section? That would reduce the amount of space available for detail records.

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

    Re: Subform scrolls up after each line (2000)

    "The top of the screen"? If you are only displaying a single row or two in your subform, then there is no place else for the empty new record to appear when you tab out of the newly created one.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform scrolls up after each line (2000)

    The dimesions are:

    Header Ht: 0.556
    Detail Ht: 0.698
    Footer Ht: 1.199
    Subform Ht: 6.481

    By eye I would say that there should be room for about 5 records to be added before the first record scrolls off the top of the form.
    The default view of the subform is Continuous and the views allowed property is det to Form.

    Ian

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

    Re: Subform scrolls up after each line (2000)

    Could you post a stripped down copy of the database? That would enable us to look at the problem directly. See <post#=371550>post 371550</post#> for instructions.

  6. #6
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform scrolls up after each line (2000)

    Here it is. I think it may be to do with the code in the onCurrent event, although why it should cause the behaviour it does is a mystery to me.

    Thanks for your help.

    Ian
    Attached Files Attached Files

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

    Re: Subform scrolls up after each line (2000)

    Put a control bound to TxTime somewhere on the form. It can be in the form header or footer or in the detail section, and it can be hidden (Visible = False).

  8. #8
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform scrolls up after each line (2000)

    It worked. Thanks again.
    That's my immedeate problem solved, but I'd be interested to know why it worked?
    Ian

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

    Re: Subform scrolls up after each line (2000)

    Frankly, I don't know. Since the code in the On Current event was clearly the culprit (the problem went away if I commented out the code), it occurred to me that the problem could be caused by the lack of a control bound to the TxTime field. But I have no good explanation for the behavior.

Posting Permissions

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