Recent content by russdirks

Sure it works, but you've significantly reduced functionality compared to my version! Where's the code in the On_Current event to update the status bar? I already knew that removing that code would fix the problem, but that code is important and needs to stay.

The subform has only about 15 records, but in the on_current event of the subform my code does an aggregrate query on a table with about 7000 records. If I comment that out, it works fine. I was just putting together a stripped down version when I found the solution. See attachment if you're...

Absolutely! Sorry if you didn't feel I was giving you the credit you deserved. I just wanted to provide the exact details for anyone else who might find this thread, since your instructions were more general in nature, and there are so many different combinations that one could try, with only...

I finally got it working. The solution was to call the MoveLast/MoveFirst method of the subform Recordset from the Load event of the main form. And it had to be exactly that combination. It couldn't be the RecordsetClone object, it couldn't be in the Open event, and it couldn't be in the...

I know it's an old thread but I am having the same problem as the OP and was wondering if a solution was ever found. I have a subform with more data than can be displayed in the available space, and the vertical scrollbar does not appear until I force scrolling to take place by pressing the...