Updating control on mainform causes subform to scroll to en

[JaneC]

I have a subform showing details of requests that have gone off to consultants. When a request is added on this subform I need to update a control(ReqStat) on the main form. When I add a new record it updates the control Ok and then returns to the 'new' record at the end of the form. When I try to add another new record, all the existing records appear to disappear, just showing the new one. It appears to be activating the on current event twice for the new record. If I comment out th eline that updates reqstat then it works fine. i.e. new records show at the bottom of the subform.

Any help gratfully received !

 

[JoeMiller]

Could it be that the subform is just scrolling up for you automatically? Try hitting the up arrow on the scrollbar and see if the records are there, just up out of view. I'm not tryin to sound rude, I had that happen once til I realized I just needed to scroll up.

HTH Joe Miller
joe.miller@flotech.net

 

[JaneC]

Yes, they are still there, and can be accessed using the up arrow at the top of the scroll bar, the scroll bar itself doesn't work. I need the form to still show all the previous records without having to scroll up - which it does if the line of code to update the control on the main form is commented out.

How can I stop it scrolling up ??

 

[JoeMiller]

Not sure on that one, maybe you could set focus first record in the subform? Rather than the new record?

Joe Miller
joe.miller@flotech.net

 

[JaneC]

Thanks Joe,

The existing records don't "disappear" until the first control on the new record is accessed (a combo box) so I'm not sure this would work.

Looks like it's back to the drawing board !

Jane X-)