BananasInPajamas
New member
- Local time
- Today, 14:13
- Joined
- Apr 4, 2011
- Messages
- 9
I have a subform (continuous form) that requeries on a timer set to 1,800,000 (30 min) that way new record are will be shown I'd like to have the subform requery to show new records everytime a new record has been added. I can get the subform to requery with the AfterUpdate method, but once the subform requeries only the new record is shown at the very top and users would have to scroll up to see previous records. Is there a way to requery when a new record has been entered and now show just the new record? I'm a VBA newb, so please explain the code so a newb such as myself can understand. Thanks for your help guys, it's much appreciated!