I have 3 forms to manage people and groups. Form1 is the main form where I have a combobox to select which group to use. Form2 is a subform that lists all the people who are members of the selected group. Form3 is a subform that lists all the people who are not members of the selected group.

Form2 and Form3 are continuous forms. Form2 has a 'Remove'-button to drop people from the group and Form3 has a 'Add'-button to add people to the group.

Everything works quite well, when I add or drop a person from the selected group I refresh the current subform and requery the other subform.

When I refresh the current subform the cursor moves to the first record which can be pretty annoying if the user has to scroll down almost everytime there has been a refresh. My workaround is to use the recordsetclone to find the next row, and then I move to that row with DoCmd.FindRecord after the refresh. It works, but it's quite ugly since the list 'jumps' up/down depending on the situation.

In a perfect world I want the subform to be refreshed, the closest record selected and minimal vertical scroll whenever possible. Maybe I have to rethink the entire design... Any suggestions?

Without seeing the design, does Tab Order come into play (right click on the form, select Tab Order)?

HTH


mmcdonal

If you're sorting the lists by the person's name, your idea is great. I'm not quite sure about why the flickering occurs but here's one way to minimize it.

Sort the list by the descending date and time that the person was added to that particular list. In that way, the newest person will always be at the top of the list. When the subforms refresh, the person (and cursor) will always be at the top ANYWAY... no flicker. :D

Of course, if you want to sort by person name, then letting us see the design as MMcDonal asks may help.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for the feedback! I'll post some screenshots later, I'm at work right now :)

http://www.avectris.com/jumping.gif

Here is a screenshot that shows the three forms. I have clicked the last row in the form to the right and the effect is shown in the bottom picture.