have form stay on current record

[JamesRocklyn]

I have a calendar, where the left side of my form has constant data and the right side displays meetings for the week. When I toggle to my next weeks events, my form goes to the first record and I cannot figure out how to keep it on the current record. I have looked at .bookmark but that isn't making sense to me, I have figured out how to count the mouse scroll, so I know I am on record 17 (as an example) but the only way I have been able to update my calendar based on it being a different week is to do a requery and then I can't get back to record 17. It looks like I should be working in datasets but have not found good explanations or videos to show how this would work.

[pbaldy]

Does this help?

http://www.baldyweb.com/Requery.htm

[ranman256]

You can filter the record so its the only date records needed:

me.filter = "[date] between #" & me.txtStartDate & "# and #" & me.txtEndDate & "#"
me.filterOn = true