Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reposition the pointers on the subforms

    Dear all,

    I have a form that displays 3 subforms. The subforms are all Continuous Forms based on queries.

    I have a snippet of code triggered by the timer event of the main form. This requery

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

    Re: reposition the pointers on the subforms

    Subforms also can have recordsetclones. Basically, you store the current record's key in a variable and then use that value to find the same record in the subform's recordsetclone after the subform requeries. Then you set the subform's bookmark to that bookmark.

    You may need to disable the timer in the command button event and restart it again after the calculation is over. Timers look handy, but I've always found them to be more trouble than they're worth, especially when they kick in during another operation.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: reposition the pointers on the subforms

    I agree with Charlotte, the timer seems to be the cause of your problems. Yes, there are ways around it (like she suggested), but why do you have it?

    As for highlighting a row, you have that capability in Access2000. You need to look at the conditional formatting capabilities. This allows you to change the backcolor property of controls when they are on the selected row.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: reposition the pointers on the subforms

    Thank you for your prompt replies.

    The reason I

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: reposition the pointers on the subforms

    I'm not sure I completely understand the situation. I guess it is on a form that is pretty much kept open constantly? How often does the requery happen?

    It seems the problem is that the user doesn't know when the subform has requeried. One possible solution would be to use listboxes instead of subforms. You could then set the listbox's listindex property to -1 after a requery, indicating no selection has been made.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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